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 |
|
mvanwyk
Yak Posting Veteran
99 Posts |
 Posted - 2009-10-13 : 08:04:42
|
| Hi Guys.I just completed this how to configure tranaction log shiphttp://msmvps.com/blogs/omar/archive/2006/09/15/How-to-setup-SQL-Server-2005-Transaction-Log-Ship-on-large-database-that-really-works.aspxAnd step 29 explains that i need to restore the log file which i did exactaly to the point."REMEMBER: go to options tab and set the Recovery State to "RESTORE WITH STANDBY" before you hit the OK button."So now the DB is still in StandBy / Read only modeeven after step 53 why is that or have a missed a step somewhere?Just a side note.I created a table in my primary DB the job log report all steps where completed 100% but if i look at the secondary DB the table is not there?What am i missing? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-13 : 09:05:47
|
quote:
Originally posted by mvanwyk
So now the DB is still in StandBy / Read only modeeven after step 53 why is that or have a missed a step somewhere?
That's correct. The secondary has to be either recovering or standby to allow further logs to be restored.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
StandBy / Read only mode