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 |
|
sfitton
Starting Member
1 Post |
 Posted - 2008-04-23 : 17:31:45
|
| I am new to this environment and was asked to ensure that the transaction log shipping for SQL 2005 on W2K3 boxes is working properly. I noticed the db's on the secondary server are show "Restoring..." I am not sure if these were set up in No Recover Mode or Standby Mode. I have no access to the secondary db's. I get an error message when trying to access them (error 927). Monitoring was not set up initially and as you may or may not know can't be turned on after the fact...unless you delete the job and start over.My question is is "Restoring..." normal and what does it indicate? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-23 : 17:35:03
|
| It means you can apply logs to secondary database. You can't access unless you put in standy(read-only) mode. |
 |
|
|
|
|
|
Secondary DB in "Restoring..." state