学步园

备份语句：

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'