Thursday, June 18, 2015

Shrink eMO database log file in SQL 2005/2008

Shrink Log file of eMO database in SQL 2008

Steps to Shrink DB Log

1. In SQL Server Management Studio
2. Right click on the eMO database and go to Properties:-
3. Go to "Options" on the left.
4. Change the "Recovery Model:" from Full to "Simple" and hit OK

5. Right click on the eMO database again, go to Tasks - Shrink – Files

Then Under File Type: select Log and then tick Release Unused Space then click OK

Download Full document

Thanks to Md.Nadim System Administrator Head Post OfficePurnea - 854301.
Ph.(O) - 06454242751

1 comment:
Write Comments