Post reply

tlog backup job

  • June 16, 2005 at 4:34 pm

    #109548

    Is it possible to creat a job that will run multiple tlog backups? For example;

    BACKUP LOG test to test_bk

    BACKUP LOG test1 to test1_bk

  • June 16, 2005 at 5:38 pm

    #566285

    Yes, it's possible.  You can put the backup commands for each database in a separate job step.  See "creating jobs" and "backup log" in BooksOnLine.

    Greg

     

    Greg

  • June 16, 2005 at 9:44 pm

    #566293

    You might also want to look at Tara Duggans' backup scripts.  You can just paste them into a job and run them.

    http://weblogs.sqlteam.com/tarad

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • June 28, 2005 at 4:21 pm

    #569173

    Thanks for your feedback. I actually had the job set up correctly with multiple backup log request, but unfortunately did not have the correct databases loaded on my DR machine (Duh...)

    Thanks again.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply