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