Friday, May 6, 2022

Change recovery mode

 Change Database recovery mode to normal mode

DBCC CHECKDB ('YourDBname') WITH NO_INFOMSGS, ALL_ERRORMSGS

Shrink database size
DBCC SHRINKDATABASE ('YourDBname') ,10);