Tag Info

New answers tagged


I had the numbers incorrect. The shrink was done and the size was 0.3TB. So SQL Server had 6 times the allocated storage, not 2 times the allocated storage. I resolved this by creating a target definition (by importing the table schema in Informatica) after I removed the indices on the target table. SQL Server was allocating the disk space, even though ...


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 ...

Top 50 recent answers are included