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 |
|
mechamonkey
Starting Member
8 Posts |
 Posted - 2006-06-12 : 07:27:12
|
| Hi all,I have set up a log shipping pair using the database mainentance plan wizard, set full backup every day on primary, 15 mins interval for transaction shipping.My questions are : 1) Is it possible to perform a point in time restore on the primary database using the database backups/transaction logs generated by logshipping? 2) If so how? 3) Will the changes on the restored primary then be shipped across Many Thanks. |
|
|
mechamonkey
Starting Member
8 Posts |
Posted - 2006-06-13 : 05:33:34
|
| Nevermind, I've sorted it now. |
 |
|
|
mechamonkey
Starting Member
8 Posts |
Posted - 2006-06-20 : 09:28:28
|
| Arg, back again :)Well I got everything working fine except when restoring the primary server to a previous point in time breaks the log shipping on the secondary server.The secondary server does NOT restore any logs after you restore the primary as the transaction log sequence is out of order.Is there a quick fix around this apart from either:1. Restoring the secondary from same backups I used on the primary2. Deleting the secondary database and running the entire Database Maintenance Task wizard to restart the process.Thanks againGo to Top of Page |
|
|
|
mechamonkey
Starting Member
8 Posts |
Posted - 2006-06-21 : 03:27:43
|
| Just to answer myself again as reference for anyone else trying this, you cannot simply restore the primary db, you must re-initialise any log shipping pairings afterwards. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-21 : 09:39:08
|
| Not tried it, but could you simultaneously restore the second server to the same place (in the Tlog backup chain)?Kristen |
|
|
|
mechamonkey
Starting Member
8 Posts |
Posted - 2006-06-22 : 10:56:15
|
| Yes Kristen, thats what I ended up doing in the test scenarios. |
|
|
|
|
|
|
Point in time restore of primary log shipping DB.