ABI TECH NEWS
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment