备份

---

  

USE master godeclare @path varchar(100),@name varchar(100);set @path='d:\backup\';set @name=@path+'TsDb.bak';Backup database TsDb To disk= @name With init  --完整覆盖备份

 

 

 

还原

---

 

RESTORE DATABASE TsDb_NFROM DISK =  'D:\DB\TsDb.bak'   --bak文件路径with replace,MOVE 'TsDb' TO 'E:\DB\TsDb_N.mdf',   --mdf保存文件路径MOVE 'TsDb_log' TO 'E:\DB\TsDb_N_log.ldf'  GO