So Tired !_! 逆水行舟, 不进则退!

4Nov/14

mssql log clear and shrink file

Posted by Nick Xu

1
2
3
4
ALTER DATABASE testdb SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(testdb, 1)
DBCC SHRINKFILE(testdb_log, 1)
ALTER DATABASE testdb SET RECOVERY FULL WITH NO_WAIT
Tagged as: , Comments Off
   
site
site