Compact and Repair in an adp
This is a discussion on Compact and Repair in an adp within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi, I just deleted about 1 million records from a SQL Server 2000 database. I access it using Access ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-01-2008, 02:49 PM
| ||||
| ||||
 Compact and Repair in an adp Hi, I just deleted about 1 million records from a SQL Server 2000 database. I access it using Access 2000. I have Compact and Repair available in the adp under Tools. Should I do that from Access? Will it not mess anything up? Thanks! J~      |
|
03-01-2008, 02:49 PM
| |||
| |||
| Re: Compact and Repair in an adp JA wrote: > I just deleted about 1 million records from a SQL Server 2000 database. I > access it using Access 2000. > > I have Compact and Repair available in the adp under Tools. Should I do that > from Access? Will it not mess anything up? No idea. You can definitely use Query Analyzer to run a DBCC SHRINKDATABASE command. If you expect the database to grow back to its previous size and stay there, then you shouldn't shrink it. If you expect it to stay at its reduced size, then you should. |
|
03-01-2008, 02:49 PM
| ||||
| ||||
| Re: Compact and Repair in an adp JA (jarmour@kc.rr.com) writes: > I just deleted about 1 million records from a SQL Server 2000 database. I > access it using Access 2000. > > I have Compact and Repair available in the adp under Tools. Should I do > that from Access? Will it not mess anything up? To me that sounds like tools for the local Access database. In any case, one million rows is not that much, unless the rows are extremely wide. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
Linear Mode
