tran log backups in SQL 7

• ksexton

  SSCrazy

  Points: 2790

  More actions

  October 19, 2004 at 1:02 pm

  #109602

  How can I setup tran log backups in SQL 7 every 2 hours?

   

   

• cutiger93

  SSC-Addicted

  Points: 485

  More actions

  October 20, 2004 at 5:51 am

  #527301

  You can use a database maintenance plan or you can use a script to backup and schedule is for every two hours.

  Here is an example:

  Management-> Database Maintenance Plans-> New Maintenance Plan-> Choose the Database->

  Uncheck the backup and then check the transaction log.

  Click on the schedule button and then set it up to the time of your liking.

  Example 2:

  Do the following:

  Management-> SQL Server Agent-> Jobs-> New Job

  Create a job and include the following script in steps:

  BACKUP LOG MyNwind

  TO MyNwind_log2

  Create a schedule under schedules:

  Schedule the job at the appropriate time.