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 |
|
swekik
Posting Yak Master
126 Posts |
 Posted - 2009-03-03 : 11:39:59
|
| How much time will it take to shrink a data file of size 110GB and has 70Gb worth of data and trying to shrink it to 75 GB ? |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-03-03 : 13:39:25
|
| Since we don't know the configuration of your server, hardware, datafiles, etc., there is no way for us to say for sure.Why don't you just shrink it and see how long it takes?Edit:Since Tara mentioned the shrink script, I added the link to it:Shrink DB File by Increment to Target Free Spacehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80355CODO ERGO SUM |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-03-03 : 16:46:05
|
| Generally, it is not recommended to shrink database files (unless you have very compelling reason to do so and I hope you really do :) ) |
|
|
|
|
|
|
Shrinking Files