Monday 21 June 2010

Shrink database - To clear the Log File & Increase the Free space

To Run this SQL Query To Shrink the SQL Database , To clear the Log File & Increase the Free space of Hard Disk


exec sp_msforeachdb @command1 ='dbcc shrinkdatabase (?, 10)', @replacechar ='?'

No comments:

Post a Comment