EXEC sp_MSForEachDB 'DBCC SHRINKDATABASE (''?'' , 0)'Hope it helps.
Tuesday, November 24, 2015
MsSQL: Shrink ALL Databases Using 1 Single Line of SQL Statement
Over time, the database logs on your database server may take up significant amount of disk space especially if there are many databases with lots of transactions. One quick method to free up disk space is to "shrink" your databases. Instead of shrinking one database at a time using the GUI, you can run a single line of SQL statement to do just that.
Hope it helps.
Hope it helps.
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Get accurate and real-time bus arrival information for public bus operators in Singapore, including SBS Transit, SMRT Buses, Go-Ahead Singap...
-
*********** Try to sleep now, close your eyes Soon the birds would stop singing Twinkling stars, are shining bright They'll be watch...
-
I would like to apologize that sigining of my guestbook is not possible at the moment due to an unexpected bug. There is already 74 entries ...
-
Google url shortener service, goo.gl , is now much improved with newly included features like easier copy and paste, and ability to delete e...
-
Why I choose to remain single Sun, Apr 05, 2009 - The Straits Times My parents have a loving relationship, but I knew I could not live my li...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.