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 |
|
mcbinu
Starting Member
3 Posts |
 Posted - 2008-08-08 : 02:08:38
|
| I have an issue in Transaction log shipping setup1) One SQL2005 database (TEST1) configured as Primary server in log shipping and another one (TEST2) configured as secondary server . 2) Status of TEST1 during log shipping is 'ONLINE' and TEST2 is 'STAND BY'.3) Log shipping from TEST1 to TEST2 and restoration of copied logs at TEST2 is also working fine.3) TEST1 & TEST2 are physically located at different places.Now I want to configure TEST1 as secondary and TEST2 as primary and apply logs genrated from TEST2 in TEST1 database without restoring full backup from TEST2.1) Changed the status of TEST2 database to ONLINE from 'STATND BY ' mode using RESTORE LOG COmmand.But I can not Change the status of TEST1 database to STANDBY to test the log shipping and rstoration from TEST2 to TEST1 .When I tried RESTORE LOG command it saying " Database already in FULLY RECOVERD state and can not perform this operation".Please Help me to resolve this issue |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-08 : 10:17:57
|
| Here is what you need to study:http://msdn.microsoft.com/en-us/library/ms178117.aspx |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-09 : 00:09:22
|
| You need restore db on test1 first. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-10 : 14:36:48
|
| You don't need to restored whole DB on TEST1. You can do with Log restore. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-10 : 17:19:33
|
| >> I can not Change the status of TEST1 database to STANDBY to test the log shipping and rstoration from TEST2 to TEST1 .You can change that with 'backup log test1 to disk = ... with standby = ...', but don't know if you can apply log from test2 without restoring full backup and keep test1 in standby mode. Will work in norecovery mode although. |
|
|
|
|
|
|
SQL Transaction Log shipping issue