数据库备份与还原.doc

-完整备份Backup Database db_database To disk=D:Backupdb_database_Full.bak-差异备份Backup Database db_database To disk=D:Backupdb_database_Diff.bak With Differential-日志备份，默认截断日志Backup Log db_database To disk=G:Backupdb_database_Log.bak-日志备份，不截断日志Backup Log db_database To disk=G:Backupdb_database_Log.bak With No_Truncate-截断日志不保留Backup Log db_database With No_Log-或者Backup Log db_database With Truncate_Only-截断之后日志文件不会变小-有必要可以进行收缩