SQL Server Performance

Log Shipping Fail Over & Questions

Discussion in 'SQL Server Log Shipping' started by spepi, Jun 20, 2005.

  1. spepi New Member

    I just set up Log Shipping. Im new to SQL, so excuse me if I get some terms wrong.

    1. Log Shipping seams to be working...I can see the .trn files backed up the secondary machine, secondry machine db is in read only mode. When I look at SQL logs, I keep seeing errors like this, but obviously different time stapms.
    The log shipping source (LOCAL).WebReg has not backed up for 1129 minutes.. WebReg is my DB. What steps should I take to find out the cause of this.

    2. What steps do I need to do to use the secondary server? I want to implement a server failure and see how the failover method works, but I dont understand what I need to do.

    I have a server to monitor, but the out of sync error is there. When I created the log shipping, I didnt have a webreg DB on the secondary machine, so I created one during the setup. how do I get them to sync? Network is fine, time is right on....any ideas>

    thanks



    Ma.
  2. satya Moderator

    1) True on the secondary server the database must be in read-only mode in order to restore Transaction logs. The message you're getting is an informational message and ensure the log shipping monitor is not generating any other alerts/errors related to log shipping retore.

    2)http://www.sql-server-performance.com/sql_server_log_shipping.asp gives you in-depth information.

    In order to sync. the database before log shipping it mustbe restored onto the secondary server and then log shipping to continue in restoring the logs.



    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. spepi New Member

    Thanks..I printed out the link, but when I get to create stored procedures on secondary server, I cant access my read only DB.



    Ma.
  4. spepi New Member

    Ok..still lost. How do I do a restore using the read only copy.....

    Ma.
  5. satya Moderator

    Why do you want to create the objects on the secondar server database, as it should bein read-only mode and when the log shipping schedule statrs, the transaction log will be restored accordingly.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. spepi New Member

    I was able to get the log shiping to work, the nit went bezerk..I cant get rid of Error 14261: The specified primary_server_name.primary_database_name ('N') already exists.

    I have removed, dettached, attached, reinstalled, Im am dead in the water

    Ma.
  7. satya Moderator

Share This Page