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 - 2005-10-19 : 05:36:35
|
| Kat writes "Hi,We need to shrink one of our production databases - SQL Server 2000, service pack 4. The size of the database is currently 26GB in size, with about 40-50% free space.We have concerns about the performance impact of running the DBCC SHRINKDATABASE statement.I would like to hear other people's experience with running this command.My understanding is that it will NOT take the database offline, that is, users can still query the database - but is it going to create a serious performance problem? Also, approximately how long would a shrink of this size take?In addition to these questions, I need general recommendations about shrinking the database, caveats, etc.Thanks!!" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-19 : 06:35:55
|
| if the log file will grow to this size again, better leave it as is and start doing regular log backups to maintain the size and only increase when neededshrinking the log file will strip you off the option to restore to a certain point,the log file will still grow, the solution is to maintain the size at a manageable levelHTH--------------------keeping it simple... |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-10-19 : 09:31:46
|
| Whoa! Major Deja-Vu here..http://www.tek-tips.com/viewthread.cfm?qid=1138712&page=1 |
|
|
|
|
|
|
DBCC SHRINKDATABASE Question