Category Archives: SqlServer

SQL Server: Shrink Transaction Logs

Posted on July 26, 2018 by Jianming Li

Script — Backup database: USE master; BACKUP DATABASE dbname  TO DISK = ‘D:\Backup\dbnameFull.bak’ WITH FORMAT;    GO   — Backup transaction log: BACKUP LOG dbname TO DISK = ‘D:\Backup\dbnameLog.TRN’ GO   — Set recovery mode to SIMPLE: USE master; ALTER … Continue reading →

Posted in SqlServer | Comments Off on SQL Server: Shrink Transaction Logs