Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Shrink .mdf
- Thread starter rexc
- Start date
goldwhispers
Programmer
well if your dbase is just getting bigger and bigger maybe you need to check on what kind of recovery model you have in the database properties, maybe you only need simple recovery and are on full, ie. what are you needs, what kind of dbase is it?
another thing though is if your database is getting bigger and bigger and if you start shrinking it regularly you are going to internally fragment externally fragment the disk drive, so the solution is not to just shrink there are a few things you need to take into consideration and i would start with your recovery model - preferably leave the database larger rather than it growing all the time because that also uses more resources - i hope this makes sense
another thing though is if your database is getting bigger and bigger and if you start shrinking it regularly you are going to internally fragment externally fragment the disk drive, so the solution is not to just shrink there are a few things you need to take into consideration and i would start with your recovery model - preferably leave the database larger rather than it growing all the time because that also uses more resources - i hope this makes sense
- Status
Similar threads
- Locked
- Question
- Locked
- Question