Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to apply transaction log from physical file to restored DB? Expand / Collapse
Author
Message
Posted Friday, September 13, 2013 3:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 8, 2013 2:43 AM
Points: 2, Visits: 12
The .mdf file rendered 0kb after storage error. Older backup was restored , but the transaction log is available as a file from the production server. How to restore the updates from the tran file?
Post #1494741
Posted Friday, September 13, 2013 3:41 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:05 AM
Points: 42,829, Visits: 35,961
The answer to that was to take a tail-log backup before you restored over the damaged database....


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1494751
Posted Friday, September 13, 2013 4:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 8, 2013 2:43 AM
Points: 2, Visits: 12
It was a different team - Storage people working, I am given only the .log file.
What are the chances now?.
Post #1494761
Posted Friday, September 13, 2013 6:43 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:05 AM
Points: 42,829, Visits: 35,961
Maybe possible, maybe not.

You'll need to hack the database back into the server (google for hack attach Paul Randal)
Then, if that's successful, you'll need to see if you can take a tail log backup. Requires that the database was in full recovery with an unbroken log chain at the time of the disaster.
Then you'll probably have to restore the database again, leaving it in the RECOVERING state, then apply all log backups that were taken between when the full backup you used was taken and the time of the disaster. If any are missing or if there was any break in the log chain you won't be able to restore.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1494767
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse