SQL Server Performance Forum – Threads Archive

Maintenance Plan

I backup my sql via maintance plan. My maintenance plan dumps the database and transaction log. Which order should I dump the database and transcation log. I recovery mode is set to full and My transcation log dump is done 4 time a day…from 10-10:30 every 4 hours.

Check: http://www.sql-server-performance.com/backup_restore_tuning.asp HTH
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>