Simple Backup Plan Question I'm using Microsoft SQL Server 2016 Standard (64-bit). I have the following backup plan (9 steps long) ...
What I want is just one full (simple) backup everyday.  Do I need to do step 8 (Backup Transaction Log)? Or can I just run some kind of query like &quot;TRUNCATE Transaction Log&quot; after the backup is done? And am I missing any steps, or running something I shouldn't?
&quot;Management&quot; - &quot;Maintenance Plans&quot; - &quot;My_Maint_Plan&quot;

Check Database Integrity
Shrink Database
Reorganize Index
Rebuild Index
Update Statistics
Clean Up History
Backup Database (Full)
Backup Database (Transaction Log)
Maintenance Cleanup Task

This plan creates 2 files daily ... .BAK (1.7 gig), and .TRN (8 gig) ... Do I really need the 8 gig TRN file?
If you don't want point-in-time restore for your databases, switch them to SIMPLE recovery, and simplify your maintenance to:

Check Database Integrity
Update Statistics
Backup Database (Full)