Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007
    Posts
    6

    Red face Unanswered: How to rebuild logshipping after role change

    Hi ,
    I am working on logshipping DRS trail and have done role successfully.
    Now after doing the role change I want to rebuild the logshipping for database which is already existing in secondary server.
    I tried adding destination server with existing database. It gives me message as " The database is not in standbymode to do logshipping". Can anyone help me on this.
    How should I bring the existing database in warm standby mode.

    Thanks
    Md.S.Hassan

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    You will have to restore the database on the secondary ensuring that you specify NORECOVERY. Then add the logs (again with NORECOVERY) until you are current.

    -- This is all just a Figment of my Imagination --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •