Home > IT Answers > SQL Server > Shrinking a SQL Server database
SQL Server Ask the Experts
2,585 pts.
 Shrinking a SQL Server database
SQL Server database, SQL Server Database Consolidation, SQL Server databases
What is the best way to shrink a database? What are the alternative methods?

Software/Hardware used:
ASKED: July 6, 2009  4:57 PM
UPDATED: July 6, 2009  9:55 PM
RELATED QUESTIONS
Answer Wiki:
The only way to shrink a database is to use the DBCC SHRINKDB or DBCC SHRINKFILE statements. However databases should not be shrunk on a regular basis as it causes a large amount of index fragmentation and will hurt your database performance.
Last Wiki Answer Submitted:  July 6, 2009  9:55 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _