Amazing scenario

OK Here it is.
The production database was detached so it could be moved. Upon
reattachment it decided it was corrupt and refused to allow me to reattach.
Another member of the dba team had a physical copy of the MDF and LDF from a
few days ago. He copied the current files off for safe keeping and
reattached the old copy. Now he wants to apply the current LDF log to the 5
day old database that was attached. Is this possible?
This nightmare is neverending. Please someone help!
Richard> He copied the current files off for safe keeping and reattached the old copy. Now he want
s to
> apply the current LDF log to the 5 day old database that was attached. Is this po
ssible?
No, SQL Server keep track of the internal "timestamp" of the database files
and you have to attach
from the same point in time. Otherwise, we would have chaos.
I suggest you open a ticket with MS Support and see if they can assist with
the attach. I always do
a DBCC CHECKDB and also a backup before these things, btw...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:uDSpGga3GHA.5024@.TK2MSFTNGP02.phx.gbl...
> OK Here it is.
> The production database was detached so it could be moved. Upon reattachm
ent it decided it was
> corrupt and refused to allow me to reattach. Another member of the dba tea
m had a physical copy of
> the MDF and LDF from a few days ago. He copied the current files off for
safe keeping and
> reattached the old copy. Now he wants to apply the current LDF log to the
5 day old database that
> was attached. Is this possible?
> This nightmare is neverending. Please someone help!
> Richard
>

Amazing scenario

OK Here it is.
The production database was detached so it could be moved. Upon
reattachment it decided it was corrupt and refused to allow me to reattach.
Another member of the dba team had a physical copy of the MDF and LDF from a
few days ago. He copied the current files off for safe keeping and
reattached the old copy. Now he wants to apply the current LDF log to the 5
day old database that was attached. Is this possible?
This nightmare is neverending. Please someone help!
Richard
> He copied the current files off for safe keeping and reattached the old copy. Now he wants to
> apply the current LDF log to the 5 day old database that was attached. Is this possible?
No, SQL Server keep track of the internal "timestamp" of the database files and you have to attach
from the same point in time. Otherwise, we would have chaos.
I suggest you open a ticket with MS Support and see if they can assist with the attach. I always do
a DBCC CHECKDB and also a backup before these things, btw...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:uDSpGga3GHA.5024@.TK2MSFTNGP02.phx.gbl...
> OK Here it is.
> The production database was detached so it could be moved. Upon reattachment it decided it was
> corrupt and refused to allow me to reattach. Another member of the dba team had a physical copy of
> the MDF and LDF from a few days ago. He copied the current files off for safe keeping and
> reattached the old copy. Now he wants to apply the current LDF log to the 5 day old database that
> was attached. Is this possible?
> This nightmare is neverending. Please someone help!
> Richard
>

Amazing scenario

OK Here it is.
The production database was detached so it could be moved. Upon
reattachment it decided it was corrupt and refused to allow me to reattach.
Another member of the dba team had a physical copy of the MDF and LDF from a
few days ago. He copied the current files off for safe keeping and
reattached the old copy. Now he wants to apply the current LDF log to the 5
day old database that was attached. Is this possible?
This nightmare is neverending. Please someone help!
Richard> He copied the current files off for safe keeping and reattached the old copy. Now he wants to
> apply the current LDF log to the 5 day old database that was attached. Is this possible?
No, SQL Server keep track of the internal "timestamp" of the database files and you have to attach
from the same point in time. Otherwise, we would have chaos.
I suggest you open a ticket with MS Support and see if they can assist with the attach. I always do
a DBCC CHECKDB and also a backup before these things, btw...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:uDSpGga3GHA.5024@.TK2MSFTNGP02.phx.gbl...
> OK Here it is.
> The production database was detached so it could be moved. Upon reattachment it decided it was
> corrupt and refused to allow me to reattach. Another member of the dba team had a physical copy of
> the MDF and LDF from a few days ago. He copied the current files off for safe keeping and
> reattached the old copy. Now he wants to apply the current LDF log to the 5 day old database that
> was attached. Is this possible?
> This nightmare is neverending. Please someone help!
> Richard
>