USE mydbname GO ALTER DATABASE mydbname Set Recovery Simple GO ALTER DATABASE mydbname Set Recovery Full GO DBCC SHRINKFILE ('mydbname_log', 1) GO
Computer, Technology, Databases, Google, Internet, Mobile, Linux, Microsoft, Open Source, Security, Social Media, Web Development, Business, Finance
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)
-
Google url shortener service, goo.gl , is now much improved with newly included features like easier copy and paste, and ability to delete e...
-
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...
-
The below is an LTA's official MRT map that includes both current and future train network all the way to year 2024. [2 Apr 2019]: U...
-
ActiveSG is a national initiative from the Singapore government to encourage all to stay healthy and keeping fit. Membership registration i...
-
Gartner Report on the Magic Quadrant for Analytics and Business Intelligence Platforms as of February 2021.
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.