Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sbt1
Yak Posting Veteran
89 Posts |
 Posted - 2003-05-27 : 13:07:55
|
| Running MSDE 1.0 on Win2K.How do I compact the database? Obviously MSDE doesn't have any gui tools to do this. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-05-27 : 19:35:22
|
| You probably don't need to "compact" it, since it is essentially a SQL Server database, and it won't get the same benefit as an Access DB would. However, it would be helpful to run DBCC DBREINDEX on your tables on a regular basis (once a week is a good start, unless your tables have heavy insert/delete/update activity; once a day might be better then) This will reorganize the data if your tables have clustered indexes, but it will not reclaim space. You'd need to run DBCC SHRINKFILE or DBCC SHRINKDATABASE for that. Book Online details all of these.You can also try DBCC DBREINDEXALL to reindex all of the tables in the database in one go, but this command is undocumented so you should not rely on using it too often, it might not be available in future releases.Edited by - robvolk on 05/27/2003 19:37:04 |
 |
|
|
|
|
|
Compacting MSDE database?