Database Full and Tlog Backup

• binu.m.a

  SSC Enthusiast

  Points: 127

  More actions

  October 5, 2007 at 12:59 pm

  #118878

  Hi

  I have a database .I configured full backup at each monday 9.00 AM. on a backup media on local disk. I want to configure tlog backup for each one hour on seperate backup media.Each monday after taking full backup i want to overwrite the tlog backup media. Please help me to configure this scenario.

  Binu

• Kumar-386306

  Default port

  Points: 1464

  More actions

  October 7, 2007 at 3:07 pm

  #739857

  Hi,

  Check out this link.

  http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx

  Follow the same steps as provided in the weblink, for transaction log backup also.

  Regards

  Kumar

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  October 7, 2007 at 9:42 pm

  #739895

  Be careful backing up to drives not local to the machine. Network backups sometimes cause issues.