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 |
|
avipenina
Starting Member
44 Posts |
 Posted - 2008-05-12 : 03:29:44
|
| Hi,should i use the SHRINK DATABASE maintenance plan once a month on all USERS DB?if so what parameters should i put this the "Shrink Database when i grows beyond XXX MB" and the "Amount of free space to remain after shrink" THX |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-05-12 : 03:51:27
|
| Databases should not be shrunk. It fragments your indexes badly and very likely, the database will just have to grow again, causing file system fragmentation--Gail Shaw |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-12 : 09:16:50
|
| Don't shrink unless you are in emergency(drive is full). |
|
|
|
|
|
|
DBCC SHRINKDATABASE