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
0 comments:
Post a Comment