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 "TRUNCATE Transaction Log" after the backup is done? And am I missing any steps, or running something I shouldn't?
"Management" - "Maintenance Plans" - "My_Maint_Plan"
- 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?
reorganize
andrebuild
are duplication of efforts. A rebuild (the better option) is usually not needed very often on modern SSD drives. I have a big heavily used DB, I do tran log backups every 15 minutes, diff every 6 hr, full once per day, and the log backups are pretty small