Loading

Shrink SQL Server Data and Log files

The below syntax will allow you to shrink a SQL Server Database Data File and Transaction Log File


-- Truncate the log
BACKUP LOG biztalkdtadb WITH TRUNCATE_ONLY
-- Shrink Log File
dbcc shrinkdatabase (BizTalkDTADb, 10)
- Shrink Data File
dbcc shrinkdatabase (BizTalkDTADb_log, 10)

Leave a Reply

Your email address will not be published. Required fields are marked *