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...
-
A new micro clearfix hack .
-
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...
-
ActiveSG is a national initiative from the Singapore government to encourage all to stay healthy and keeping fit. Membership registration i...
-
According to an article from the MSDN , DirectoryInfo.GetFiles() method will give unexpected behaviour on 3-letter extensions. I quote Micr...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.