Forum Discussion
Best Practice for full backup and transaction log truncation
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...
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.
