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)
-
Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed m...
-
Forbes named Singapore Prime Minister wife and CEO of Temasek Holdings, Ho Ching, as the 5th most powerful woman in the world . Ho Ching is ... -
For people who like to stream US/UK stuff but don't want to pay VPN, try Hola . They have support for Windows, Android, Chrome, Firefox ...
-
An insightful article written by the Buffer on how writing great headlines on Twitter, Facebook and your Blog .
-
I have been hearing people telling me that they are suspecting their phones are listening to them because they have been seeing creepy adver...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.