Thanks for being so understanding.

Your advice came too late 😀

I used ShrinkDatabase notruncate. The GUI churned for over two days before I killed it. The dbcc command took less than...

Sorry Gail. I didn't mean to mess up your name 🙁

Hi George.

You are correct. There was an issue not too long where the process had to delete about 100 million records from our biggest table. I'm pretty sure that's reflected...

Hi George, I was rounding up to GB units. Here are the actual numbers, with their actual units:

Windows File Manager:

mdf file 575,784,960 KB

SQL Server Shrink Database GUI:

Currently allocated space...

Gail, thanks for the response. I will try your suggestion to kill the process.

This is a monster production db that we are restoring to this server to be used to...