--返回由备份集内包含的数据库和日志文件列表组成的结果集 RESTORE FILELISTONLY FROM DISK = 'd:\Northwind.bak'
--还原由BACKUP备份的数据库 RESTORE DATABASE Northwind FROM DISK = 'd:\Northwind.bak'
--指定还原后的数据库物理文件名称及路径 RESTORE DATABASE MyDataBase FROM DISK = 'd:\Northwind.bak' WITH MOVE 'Northwind' TO 'd:\MyDataBase .mdf', MOVE 'Northwind_log' TO 'd:\MyDataBase .ldf'
--强制还原,加上REPLACE参数,则在现有数据库基础上强制还原。 RESTORE DATABASE MyDataBase FROM DISK = ''d:\MyDataBase.bak' WITH REPLACE, MOVE 'Northwind' TO 'd:\MyDataBase.mdf', MOVE 'Northwind_log' TO ''d:\MyDataBase.ldf'
备份数据库,例如:
BACKUP DATABASE MyDataBase TO DISK = 'd:\MyDataBase.bak'