Rename secondary database

  • Can anyone help me to get this problem resolution. I want to rename one of my logshipping secondary database without removing existing logshipping.

  • please take a look here

  • I don't think you can without taking the log shipping offline and then rebuilding it.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • anthony.green (3/20/2012)


    please take a look here

    Can you please update the link?

  • parmodsingh (3/20/2012)


    Can anyone help me to get this problem resolution. I want to rename one of my logshipping secondary database without removing existing logshipping.

    You don't remove Log shipping completely, the Primary configuration stays in place.

    You'll need to remove the current secondary database and add the new secondary database

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

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

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

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