摘要:
--清空日志USE MasterGObackup log [数据库名称] with no_logDUMP TRANSACTION [数据库名称] WITH NO_LOGDBCC SHRINKFILE (2)--DBCC SHRINKFILE (1)GO--完整备份,每天一次USE MasterGOdeclare @str varchar(100)set @str='D:\ChaoXingBaiLianPortal\databasebk\FullBak'+replace(replace(replace(convert(varchar,getdate(),20),'- 阅读全文