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 |
|
MichaelP
Jedi Yak
2489 Posts |
 Posted - 2004-01-28 : 16:50:07
|
| If I called a shrink file from Enterprise Manager, and it's taking too long, can I cancel it? Last time I tried to cancel a query it really messed things up.Should I just wait it out? We are shrinking a 8GB database to 4GB, without reordering the pages.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-28 : 16:52:32
|
| Yes you can cancel it. I cancelled one recently that had been running for over an hour. It was shrinking a 130GB database down to 100GB. We decided to wait until later that day to kick it off again.Killing the process will take just a second or two.Tara |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-01-28 : 17:16:50
|
| Do you suggest killing Enterprise Manager, or issuing a KILL on the SPID in Query Analyzer?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-28 : 17:18:06
|
| Kill the SPID in QA. Your EM should respond after that.Tara |
|
|
|
|
|
|
Shrink Database