I am looking under backup database tasks in maintenance plans and notice the different backup types. What is the purpose of Transaction Log? Is that for backing up the transaction log? Do I need to be backing up the transaction log?
Correct - some interval that's relatively frequent.
Also, make sure when you're setting up your maintenance plans that you have a Cleanup task that deletes backups older than x number of days - otherwise
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…