SQL备份语句.docVIP

SQL备份语句.txt爱情是彩色气球，无论颜色如何严厉，经不起针尖轻轻一刺。一流的爱人，既能让女人爱一辈子，又能一辈子爱一个女人！ --完整备份 Backup Database NorthwindCS To disk=G:\Backup\NorthwindCS_Fullbak --差异备份 Backup Database NorthwindCS To disk=G:\Backup\NorthwindCS_Diffbak With Differential --日志备份，默认截断日志 Backup Log NorthwindCS To disk=G:\Backup\NorthwindCS_Logbak --日志备份，不截断日志 Backup Log NorthwindCS To disk=G:\Backup\NorthwindCS_Logbak With No_Truncate --截断日志不保留 Backup Log NorthwindCS With No_Log --或者 Backup Log NorthwindCS With Truncate_Only --截断之后日志文件不会变小 --有必要可以进行收缩 --文件备份 Exec Sp_Helpdb No