SQL Server数据库日志删除脚本
declare @dataname varchar(50)
set @dataname='VTS_MatchCenter_4.5'
backup log @dataname with NO_LOG
backup log @dataname with TRUNCATE_ONLY
DBCC SHRINKDATABASE(@dataname)
SQL Server数据库日志删除脚本
declare @dataname varchar(50)
set @dataname='VTS_MatchCenter_4.5'
backup log @dataname with NO_LOG
backup log @dataname with TRUNCATE_ONLY
DBCC SHRINKDATABASE(@dataname)