August 5, 2004 at 3:28 am
Is there any way that a database can be fully restored & recovered, modified and then set in an unrecovered state so that transaction logs can be applied?
August 5, 2004 at 6:08 am
i take it you want to make a change to the design of the database after you recover it, then you want to apply transactions from your old database.....?
i don't think so.
althought you might be able to find some tool to script up the transactions from the log. something like log PI and then see if you can apply that script after you've made your changes.
the problem is that the changes to the database design (in structure or data valaidation) might not fit with the transactions anymore (this is theoretical... i'm not sure it can be done at all)
think you might have to restore to a point in time and then rebuild the design and do some data manipulation to tget what you want.
MVDBA
August 5, 2004 at 6:20 am
Mike,
That's what I thought too. Here's another one. When log shipping a replicated database (merge repl.) is it possible to have replication ready on the secondary before changing roles or does the secondary have to be fully recovered and then replication set up after its role has been changed?
Regards,
David
August 5, 2004 at 6:31 am
from books on-line
Before performing a log shipping role change, a maintenance plan for this log shipping pair must exist on the secondary server. A maintenance plan can be created using the Database Maintenance Plan Wizard, or by adding a server as a secondary server using the Add Secondary dialog box found in the user interface of the primary database maintenance plan.
so i guess the answer is - you should set up the replication on the secondary first.
see books on line article "How to set up and perform a log shipping role change"
MVDBA
August 5, 2004 at 7:02 am
hmmm, leaving us with the problem of altering the database before applying the transaction logs.
Looks like log ship, recover and then apply replication it is then.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply