InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 18:30:26 GMT20http://www.sqlservercentral.com/Forums/Topic1373473-149-1.aspxIf you want to release space on disk then you need to shrink the database. See DBCC SHRINKDATABASE. Beware, though - if your database is likely to grow again then you're wasting resources by shrinking it, as well as causing internal and external fragmentation.JohnFri, 19 Oct 2012 01:33:53 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic1373473-149-1.aspxThanx Greatly !!!!Thu, 18 Oct 2012 08:48:30 GMTchilidogiehttp://www.sqlservercentral.com/Forums/Topic1373473-149-1.aspx[quote][b]chilidogie (10/16/2012)[/b][hr]We have a database with lab tests that we are going to merge with a different database. The original has 8,000,000 records. The new one can only bring in 100,000 at a time. I am copying the database, then deleting down to 100,000 records. However, the space on disk remains the same. Do I need to pack the database somehow to regain the space ?Thanx ![/quote]Yes. Rebuild the clustered index to recover the table space and rebuild the non-clustered indexes to regain the index space.Tue, 16 Oct 2012 16:09:55 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1373473-149-1.aspxWe have a database with lab tests that we are going to merge with a different database. The original has 8,000,000 records. The new one can only bring in 100,000 at a time. I am copying the database, then deleting down to 100,000 records. However, the space on disk remains the same. Do I need to pack the database somehow to regain the space ?Thanx !Tue, 16 Oct 2012 12:45:40 GMTchilidogie