» Documentation » SQL Reference

Restore

Syntax

RESTORE DATABASE database_name FROM SHARE {'backup directory'} 

Description

For DATABASE, database_name is the target database to restore. backup directory is a directory containing as backup database folder that includes: schema.sql and *.bin files.

For example,

BACKUP DATABASE sqltestdb TO SHARE 'c:\data' 

The backup will create a new folder 'c:\data\sqltestdb' with backup files.

To restore, execute:

RESTORE DATABASE sqltestdb FROM SHARE 'c:\data'