USE mydbname
GO
ALTER DATABASE mydbname Set Recovery Simple
GO
ALTER DATABASE mydbname Set Recovery Full
GO
DBCC SHRINKFILE ('mydbname_log', 1)
GO
Tuesday, May 17, 2011
Database Shrink MsSQL database log file
Many questions have been raised on the Internet on how to shrink the file size of a database log file. The following code snippet will do what is needed (replace mydbname with your database name).
Subscribe to:
Post Comments (Atom)
-
Gartner Report on the Magic Quadrant for Analytics and Business Intelligence Platforms as of February 2021. -
Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed m...
-
As of today, Google will start using a new shortened url - g.co , to promote Google websites. g.co works differently as compared to a long-t...
-
If you have been reading the mainstream media or the social media, it is likely that you would have heard of SimplyGo - an initiative by the... -
*********** Try to sleep now, close your eyes Soon the birds would stop singing Twinkling stars, are shining bright They'll be watch...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.