Viewing 7 posts - 1 through 8 (of 8 total)
Just wanted to circle back here and thank you for the assistance on this. I was finally able to get back on this project yesterday and found that CU's 1,...
February 28, 2019 at 2:49 pm
Hmmm, a lot of change tracking data. Retention period is set for 2 days...
February 1, 2019 at 8:27 pm
Here is the Disk Usage report after shrinking the files as much as SQL Server would allow. 1.91GB and nothing in it.
February 1, 2019 at 9:27 am
There's seriously less than 6MB being reserved by the tables in the db now. No rows in any of them. It's just not making sense.
February 1, 2019 at 9:25 am
DBName FileName FileType FileSizeMB FreeSpaceMB UsedSpaceMB
church Church ROWS 2951.31 1014.62 1936.69
church Church_log LOG 15.69 11.12 4.57
January 29, 2019 at 12:23 pm
I've deleted every single row from every table in the database. I then ran the rebuild statement on every table to reclaim used space and also rebuilt all indexes and...
January 29, 2019 at 11:45 am
The database is set to simple recovery model so transaction log size is minimal. Also the database was set to an initial size of 3GB. The actual space used is...
January 29, 2019 at 8:37 am
Viewing 7 posts - 1 through 8 (of 8 total)