Log Shipping

  • I have set up a server to monitor log shipping (SQLMon01) from a primary (SQLApp01) to a secondary (SQLApp02) and it's working just fine. I want to monitor log shipping on another system. Primary (SQLComp01) to a secondary (SQLComp02). It'll likely have a different schedule.

    Can I use SQLMon01 to monitor a second log shipping setup? I tried this once before and the old alerts were replaced with new alerts and I lost my old alerts. I was thinking I could just rename the job - LSAlert_SQLMon01 to a different name (like LSAlert_SQLApp) and set up a new LSAlert_something for SQLComp. Two different LSAlerts for the different systems would be less confusing. I really don't want to have to build another server just to monitor.

    Thanks,

    Terrie

  • A single instance can be used to monitor multiple log shipping plans

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • So can I just rename the current log shipping job and add the new one. Or when I build the new log shipping job can I change the default name so it doesn't write over the old one?

  • why rename the job?

    For each instance you want to monitor an LSAlert_instancename job is created.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • When I built the first logshipping job it defaulted to LSAlert_SQLMon01. When I tried to build a second it did the same and dropped and rebuilt LSAlert_SQLMon01 with my new alerts and I lost my original alerts. I didn't see anywhere where I had the option to name the new alerts job to LSAlert something else. Did I just not see that?

  • can you detail the steps you used to deploy the log shipping plan and whether using GUI or scripted

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 6 posts - 1 through 5 (of 5 total)

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