Post reply

Can I move the log shipping monitor?

  • October 14, 2009 at 8:16 am

    #142558

    Hi all, this may be bad form as I posted this in the SQL 2000 forum but figured more people might see it if I put it here.

    I have just been told that the server that runs the log shipping monitor for our SQL 2000 log shipped databases is to be turned off next Friday (nothing like a bit of warning).

    Can I reconfigure a new server to act as the monitor for already established log shipping processes? If not, what would I have to do?

    Thanks

    Farren Minns

  • October 15, 2009 at 3:55 am

    #1066151

    Just bumping this one to the top in case anyone can help me as I'm lost.

    Regards

    Farren

  • October 15, 2009 at 5:58 am

    #1066193

    You might check this link out - but be forewarned - it doesn't look like it's been tested.

    Since you're talking about a new server, you also could restore the system dbs from the old server to the new server.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • October 15, 2009 at 6:27 am

    #1066214

    Thanks, I'll check out the link.

    Regards

    Farren

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

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