<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=636095909-30032006>Hmmm,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=636095909-30032006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=636095909-30032006>My take on this would be to:</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=636095909-30032006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=636095909-30032006>1. Re-dump from original with the proper
flags.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=636095909-30032006>2. dump from current with proper
flags</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=636095909-30032006>3. Diff dump from orign and dump from new and set aside
changes</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=636095909-30032006>4. restore original to 'safe' DB</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=636095909-30032006>5. restore diff results over top of original in 'safe'
DB</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=636095909-30032006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=636095909-30032006>In theory, this should re-stablish the last known
state, isolate the changes, then re-append the changes.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=636095909-30032006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=636095909-30032006>This is of course the ugly way to do it. If you were
doing binary logging and you started that on the go-live date, then you could
just re-roll forward those transactions (assuming they hadn't been flushed) over
top of a restore of the original. The method above is my 'ugly' sqlDBA crippled
method (referring to my particular skills and not necessarily
yours)...</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=636095909-30032006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=636095909-30032006>G'luck</SPAN></FONT></DIV><FONT face=Arial size=2>
<DIV class=Section1 align=left>
<P class=MsoNormal align=left><FONT face=Arial size=2>Michael Eraņa,
CISSP<BR>CTO<BR>PC Network,
Inc. <BR><A
href="mailto:eranam@lanusa.com">eranam@lanusa.com</A>
</FONT></P></DIV></FONT>
<DIV><SPAN class=084512922-29032006><FONT face=Arial
size=2></FONT></SPAN> </DIV></BODY></HTML>