0
votes
1answer
51 views

Shrinking DB file in SQL Server

I have an application that writes some log data to a table. There's a nightly job that purges data older than 2 weeks. I got notified that this job has been failing for several weeks, and now the DB ...
2
votes
1answer
559 views

Optimising a Database Shrink (in terms of speed and reducing fragmentation)

We have a large database that has had a lot of older data stripped out, leaving primary datafile (all objects are currently in the primary filegroup) of about 80Gb containing a little less than 20Gb ...