备份语句:
Backup Database db_JiuShanJiu To Disk='E://DataBak//bak1.bak'
--注:貌似如果路径为C盘以外的根目录的话,执行出错。
还原语句:
USE master
DECLARE tb CURSOR LOCAL FOR SELECT 'Kill '+ CAST(Spid AS VARCHAR) FROM master.dbo.sysprocesses
WHERE dbid=DB_ID('db_JiuShanJiu')
DECLARE @s nvarchar(1000) OPEN tb FETCH tb INTO @s
WHILE @@FETCH_STATUS = 0 BEGIN EXEC (@s) FETCH tb INTO @s END CLOSE tb DEALLOCATE tb
RESTORE DATABASE db_JiuShanJiu FROM Disk='E://DataBak//bak1.bak'