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 |
|
evilDBA
Posting Yak Master
155 Posts |
 Posted - 2007-12-14 : 18:20:55
|
| I have a database with 2 almost identical tables.Each one is about 1.2 Billion rows, 0.5 Tb each.I've truncated one of them and started SHRINK DB WITH REORGANIZE PAGESIt is running already for 3 days.When should I start to worry :)Thank you in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-14 : 18:23:19
|
| You should run it in smaller chunks. It will complete much faster.Use MVJ's script to do it: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80355Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
evilDBA
Posting Yak Master
155 Posts |
Posted - 2007-12-14 : 18:27:25
|
| Thank you very muchI was not aware of thisIs it safe to stop shrink db at any moment?I think it is safe but I've heard some rumours on this forum. Dont remember where exactly... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-14 : 22:04:02
|
| I stopped that before, no issue for me. May take some time to stop for db that size. |
|
|
|
|
|
|
Shrink database takes too long (days)