[dba-SQLServer] Compact and Repair in SQL Server?

dmcafee at pacbell.net dmcafee at pacbell.net
Mon Dec 13 11:18:18 CST 2004


The term is called "Shrink" in SQL Server. Look up "Shrinking Databases" in
books online

David

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Julie
Reardon-Taylor
Sent: Monday, December 13, 2004 7:27 AM
To: dba-SQLServer at databaseadvisors.com
Subject: [dba-SQLServer] Compact and Repair in SQL Server?


What is the equivalent to a compact and repair in SQL Server?  My database
seems to be bloating.  Is there a way to schedule a compact of the database?



Julie Reardon-Taylor
PRO-SOFT OF NY, INC.
108 Franklin Street
Watertown, NY 13601
(315) 785-0319
www.pro-soft.net




More information about the dba-SQLServer mailing list