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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-14 : 08:25:09
|
| Andersen writes "Hi guys,I have checked in the forum about the Shrink and Deframentation for MSDE. The posts are very helpful. Thanks very much!But I still got some issues need to clarified.1. For the MSDE, the default option which has been turned on is the Shrink will be performed if there are 25% or more free spaces in the database. Is it must be 25%? or It can be configured into others (i.e. 30%).And How to configure it? I am using Sqlbuddy, is there any option can be choosen or i have to use the query analyser.2. For the DeFraG, I have to use the query or is there any option i can trigger?" |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Shrink and Defragmentation for MSDE 