How to clear Log file in Sql Server - 2008
Some time we see that the log file of Perticular DB becomes to huge and due to this we cant do routine work so smoothly then we do need to clear log file but some time Clearing log file (Shrink DB) query doesn’t work in SQL 2008 then we need to clear log file manually .
The process for the same is mentioned bellow with screenshots
Open Sql server Management Studio
Navigate to Databases
Right click on Database having huge log file size and selection Properties
Select Option menu on left side then change Recovery model to “Simple” then click on OK
Now again navigate to Database-right click – tasks – Shrink – file
Now change File type to “LOG” and click on “OK”
Now Again
Right click Database-properties- Select Option menu on left side then change Recovery model to “Full” then click on OK
Now Log file of your Database is fully shrink
0 Comments: