Sample Header Ad - 728x90

DBCC Shrinkfile after full backup restoration but before differential restoration

1 vote
2 answers
241 views
My database full backup file size is 760 GB and differential would be around 20 GB but the database size is around 2TB. As it is a production database, so to apply only a minimum downtime, i want to run DBCC SHRINKFILE with TRUNCATEONLY before restoring differential backup. Please advise if i can run the command DBCC SHRINKFILE with TRUNCATEONLY after full backup restored but before differential backup restoration.
Asked by kalpna (11 rep)
Jul 24, 2018, 05:22 AM
Last activity: May 25, 2025, 06:04 PM