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

4十一/14

mssql log clear and shrink file

发布在 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
   
site
site