sqlServer备份和还原语句

 1 数据库备份语句和还原语句：
 2 
 3 --完整备份
 4 　　Backup Database xxx
 5 　　To disk=’G:\Backup\xxx.bak’
 6 
 7 --查看物理路径
 8 restore filelistonly from disk = 'D:\UserFiles\Backup\xxx.bak'
 9 
10 --还原数据库
11 RESTORE DATABASE xxx
12 FROM DISK = 'D:\UserFiles\Backup\xxx.bak' 
13 WITH REPLACE,
14 MOVE 'xxx' TO 'D:\xxx.MDF', 
15 MOVE 'xxx_Log' TO 'D:\xxx.LDF',
16 STATS = 10
17 Go

 

转载于:https://www.cnblogs.com/yuan-2012/p/7283986.html