Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-24 : 08:21:54
|
| Ren Flot writes "Q: How can I tell that the log shipping restore on my standby server was successful?Background: Both ServersSQL 2000 Ent. Ed. Version 8.00.760 (SP3) OS = Win2K SP4I have implemented log shipping for 3 databases, between two SQL 2K systems, one production server (primary), and a warm standby server (secondary). The maint. plan history on the primary indicates the transaction logs were successfully backed up according to the schedule. I can't find any indication on either server as to the success or failure of the restore operation on the standby server. The maintenance plans that were created on the primary, show up in the maintenance plans for the secondary server registered in EM, but when history is viewed, there is no data. The same maintenance history on the primary server, for the same jobs, indicate success of backup...nothing about restore. I guess I could look for known changes to the primary db, on the secondary server, after the maint. plan has run (each hour). To do that, I would have to take the db's out of read-only mode. Is this a good idea?Any help! Thanks much in advance.Ren FlotGeorgia Department of Education " |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-24 : 12:35:05
|
| Where did you put the log shipping monitor? Whichever server that you selected, view the results there. You will find log shipping monitor under management in EM. But you need to know which server you selected when you configured the plan. You can also view the information in the SQL Server Error Log on the secondary server. You are looking for successful restores.You don't have to take the database out of read-only mode to view data. Viewing data is read-only work. You can run any selects that you want on a read-only database.Tara |
 |
|
|
|
|
|
|
|
SQL 2K Log Shipping (restore function on secondary)