Visitors

System Administrator Nagpur Region

System Administrator Nagpur Region

Tuesday, June 22, 2010

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

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

Free Softwares and Toolbars For Employees

Get Latest govt employees News in your mail box !!

Download our free toolbar for govt employees
A Must Toolbar For Postal employees. Free Download
Calculate your New pay on Promotion
Calculate your pension, Free softwares for employees
CAD Outsourcing