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 |
|
steel
Posting Yak Master
107 Posts |
 Posted - 2008-05-22 : 01:47:54
|
| Hello all, I am working on sql server 2000 and have a database with 21 gb of size. so we purged the database to 9 gb but when i am shrinking the database i.e. releasing the free space it is taking too much time. i mean to say that to shrink 100 mb it is taking half an hour so how i could be able to release 12 gb. note : the db is online that it is a production db.thanks in advance |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-22 : 09:22:12
|
| First of all, Why you have to shrink database of 21Gb? Its not that big. Next after shrinking , you are degrading the performance of DB as index pages will get disorganized causing Fragmentation. For production DB, you should shrink in pieces or increase disk space adding more NDF files(to different FG). Try rebuilding index in offline hours if you see performance degradation. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-22 : 22:13:00
|
| >> it is taking too much timeYes, shrinking db takes time. Good news is it's online process, you can do it on weekend. |
|
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2008-05-25 : 09:43:28
|
| sir we have purged the database so we need to free that space |
|
|
|
|
|
|
shrinking .mdf file of production server