SQL Server通过SQL语句还原数据库
示例如下:
USE master;
RESTORE DATABASE YourDatabaseName
FROM DISK = 'C:\path\to\your\backupfile.bak'
WITH
MOVE 'YourDatabaseName_Data' TO 'C:\path\to\your\database\YourDatabaseName.mdf',
MOVE 'YourDatabaseName_Log' TO 'C:\path\to\your\database\YourDatabaseName.ldf',
FILE = 1, NOUNLOAD, REPLACE, STATS = 10,
RECOVERY;
YourDatabaseName想要还原的数据库名称;
YourDatabaseName_Data要还原的数据的mdf文件的名称;
YourDatabaseName_Log要还原的数据的ldf文件的名称;
STATS = 10可以加速索引的重建过程,RECOVERY选项将数据库恢复到正常状态。