I have a 100GB data warehouse in development and I deleted about 60GB worth
of tables. Since I was running out of disk space I wanted to shrink one of
the databases. I checked the box to move the pages to the beginning of the
file. But the DBCC process has taken a week now. If I kill the process will
it take another week to bring the database back?
I don't need the data but I would rather not rebuild the database from
scratch, either. DTS jobs are saved and the so are the system dbs.
Any ideas how I might get my db back?