Tag Info

New answers tagged


Check some of the following: -Free space of DB in prod before backup. You might just have lots of free space in prod pre-reserved. It used to be a best practice before IFI was introduced. You'll still want to pre-allocate. -Transaction Log size post recovery but pre-shrink by running DBCC SQLPERF (LOGSPACE) both times. Maybe the transaction log doesn't ...


When testing my backup plan on a VM test server which was disconnected from the network I was running a backup and then used the shrink command only. I use a SIMPLE recover model, still I had to force the setting of the database to SIMPLE mode, only then I could shrink my t-logs. The conclusion seems that if you have a database in SIMPLE recover model, not ...

Top 50 recent answers are included