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 |
|
pamyral_279
Posting Yak Master
143 Posts |
 Posted - 2006-08-29 : 00:32:37
|
| I want to use function "Compact and repair database" in SQL Server2000 which like function Access 2003.How can i do ?Thank you very much. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-29 : 01:05:34
|
| The compact part is called Shrink in SQL Server. The repair part is managed all the time. The occasions were you need to check for inconsistency in the data is rare.Peter LarssonHelsingborg, Sweden |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-01 : 16:54:04
|
| "Compact and repair database"Assuming you are new to SQL Server, and come from an Access background please consider the following advice:1) As a routine measure this is unnecessary in SQL Server2) If you DO find that it appears to be necessary there is something wrong with the "tactical" maintenance of your server.If you get to the stage of being at (2) then please ask here for additional help, I'm sure someone here will be able to help you over the hurdle of migrating from Access to SQL Server and the slight conceptual mental-leap that is required in moving between the two platforms.Kristen |
|
|
|
|
|
|
Compact and repair database ?