Tuesday, 25 June 2019

SQL database shrink query

use db
go
sp_helpfile
ALTER DATABASE db SET RECOVERY SIMPLE WITH NO_WAIT
dbcc shrinkfile (db_log, 5)
--dbcc shrinkfile (db_log2, 5)
ALTER DATABASE db SET RECOVERY FULL WITH NO_WAIT

No comments:

Post a Comment