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 |
|
DanNZ
Starting Member
4 Posts |
 Posted - 2009-04-15 : 05:46:33
|
| Hi,I am running SHRINKDATABASE on ~700GB database. It has been running for about 48 hours. Is this normal?ThanksDan |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-15 : 09:56:11
|
| TOO Worst practice. All your tables will be fragmented and again it will take days to rebuild index which will fillup your log file like crazy. |
 |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-04-15 : 17:26:23
|
| How much free space did your database have when you started? |
|
|
|
|
|
|
DBCC SHRINKDATABASE