--完整備份Backup Database NorthwindCSTo disk='G:\Backup\NorthwindCS_Full_20070908.bak'--差異備份Backup Database NorthwindCSTo disk='G:\Backup\NorthwindCS_Diff_20070908.bak'With Differential--日志備份，默認截斷日志Backup Log NorthwindCSTo disk='G:\Backup\NorthwindCS_Log_20070908.bak'--日志備份，不截斷日志Backup Log NorthwindCSTo disk='G:\Backup\NorthwindCS_Log_20070908.bak'With No_Truncate--截斷日志不保留Backup Log NorthwindCSWith No_Log--或者Backup Log NorthwindCSWith Truncate_Only--截斷之后日志文件不會變小--有必要可以進行收縮--文件備份Exec Sp_Helpdb NorthwindCS --查看數據文件Backup Database NorthwindCSFile='NorthwindCS' ? --數據文件的邏輯名To disk='G:\Backup\NorthwindCS_File_20070908.bak'--文件組備份Exec Sp_Helpdb NorthwindCS --查看數據文件Backup Database NorthwindCSFileGroup='Primary' ? --數據文件的邏輯名To disk='G:\Backup\NorthwindCS_FileGroup_20070908.bak'With init--分割備份到多個目標--恢復的時候不允許丟失任何一個目標Backup Database NorthwindCSTo disk='G:\Backup\NorthwindCS_Full_1.bak',disk='G:\Backup\NorthwindCS_Full_2.bak'--鏡像備份--每個目標都是相同的Backup Database NorthwindCSTo disk='G:\Backup\NorthwindCS_Mirror_1.bak'MirrorTo disk='G:\Backup\NorthwindCS_Mirror_2.bak'With Format --第一次做鏡像備份的時候格式化目標--鏡像備份到本地和遠程Backup Database NorthwindCSTo disk='G:\Backup\NorthwindCS_Mirror_1.bak'MirrorTo disk='\\192.168.1.200\Backup\NorthwindCS_Mirror_2.bak'With Format--每天生成一個備份文件Declare @Path Nvarchar(2000)Set @Path ='G:\Backup\NorthwindCS_Full_'+Convert(Nvarchar,Getdate(),112)+'.bak'Backup Database NorthwindCSTo disk=@Path--從NoRecovery或者--Standby模式恢復數據庫為可用Restore Database NorthwindCS_BakWith Recovery--查看目標備份中的備份集Restore HeaderOnlyFrom Disk ='G:\Backup\NorthwindCS_Full_20070908.bak'--查看目標備份的第一個備份集的信息Restore FileListOnlyFrom Disk ='G:\Backup\NorthwindCS_Full_20070908_2.bak'With File=1--查看目標備份的卷標Restore LabelOnlyFrom Disk ='G:\Backup\NorthwindCS_Full_20070908_2.bak'--備份設置密碼保護備份Backup Database NorthwindCSTo disk='G:\Backup\NorthwindCS_Full_20070908.bak'With Password = '123',initRestore Database NorthwindCSFrom disk='G:\Backup\NorthwindCS_Full_20070908.bak'With Password = '123'

總結

以上是生活随笔為你收集整理的Sql server 数据库备份、恢复等的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。