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)
-
This post contains information about registration for Wireless@SG account. Sign Up You can sign up a total of 3 user accounts, one each ...
-
Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed m...
-
Gartner Report on the Magic Quadrant for Analytics and Business Intelligence Platforms as of February 2021.
-
The Mashable published 10 Chrome extensions for web developers and I bet web developers like you yourself must be using some of them. Do yo...
-
Since Google Reader started 8 years ago, I have been a great fan of it, using it on a daily basis. It is indeed sad to hear we will have to ...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.