Best Practice for full backup and transaction log truncation

Copper Contributor

I am new to SQL Server DB. Could someone please let me know what would be the best practice to do a full backup and truncate the transaction log.

If you could please let me know the strategy you are using in your company, that would give me some idea and help me learn from the documentation. I would also like to know if there is any white paper or article that explains with examples.

2 Replies

and truncate the transaction log.

@AnbarasanK040678 , shrink log files isn't best, it's more worse practice. If the workload (transactions) need the space of log, then it needs it. Shrink log means a log file growth and that's an expensive I/O traffic.

Best pratice for backup? Do it.

Back Up and Restore of SQL Server Databases - SQL Server | Microsoft Learn

@olafhelper Thanks for your kind reply.