SQL Server Performance Forum – Threads Archive

Log Shipping Fail Over & Questions

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.

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.

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.

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

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.

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.

You haven’t gave the reply about why do you want to create objects in the secondary server’s database, as it is meant to be read-only and any object creation will be affected from primary server log shipping restore schedule. Check this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;q298743&sd=tech to resolve that error.
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.

]]>