1 . 备份数据库:
BACKUP DATABASE 数据库名 TO DISK = '备份文件路径及文件名'
例如: BACKUP DATABASE TEST TO DISK = 'D:\BACKUP\TEST.bak'
2. 查看备份集中的数据库版本信息:
RESTORE FILELISTONLY FROM DISK = '备份文件路径及文件名'
例如:RESTORE FILELISTONLY FROM DISK = 'D:\BACKUP\TEST.bak'
3. 还原备份时忽略恢复数据库的文件:
RESTORE DATABASE 数据库名 FROM DISK = '备份文件路径及文件名'
例如:RESTORE DATABASE TEST FROM DISK = 'D:\BACKUP\TEST.bak'
如果备份数据集中的数据库与现有数据库不同:
添加: WITH REPLACE, NORECOVERY
例如:RESTORE DATABASE TEST FROM DISK = 'D:\BACKUP\TEST.bak' WITH REPLACE, NORECOVERY
4. 数据库一直显示"正在还原"
RESTORE DATABASE 数据库名 WITH RECOVERY
例如: RESTORE DATABASE TEST WITH RECOVERY