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

Update an old database with a newer LDF Expand / Collapse
It is possible to recover some data from the most recent log LDF file?
Poll ResultsVotes
1 - If possible with ApexSQL, but did not have and there may be another way to do this without having to resort to an external software.
 
100%
1
Member Votes: 1, Anonymous Votes: 0. You don't have permission to vote within this poll.
Author
Message
Posted Wednesday, January 29, 2014 9:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 1:05 PM
Points: 4, Visits: 6
Hi!
I have a database which was running outdated me one day and I could retrieve the LDF file.
Is it possible to update the database transactions taking log LDF file newer than I have?
thank you very much
Diego
Post #1535981
Posted Wednesday, January 29, 2014 9:36 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:58 PM
Points: 13,328, Visits: 12,826
huh?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1535983
Posted Wednesday, January 29, 2014 10:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 1:05 PM
Points: 4, Visits: 6
Sorry for the translation.
I have a database with data from two days ago.
I have a log LDF in the same database with transactions until today.
I want to recover from the current log all transactions for 2 days until today.
It's possible?
Again, sorry for the translation.
Post #1536016
Posted Wednesday, January 29, 2014 10:22 AM


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 @ 9:22 AM
Points: 40,632, Visits: 37,094
Probably not. Got any backups?


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 #1536022
Posted Wednesday, January 29, 2014 10:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 1:05 PM
Points: 4, Visits: 6
Yes, I have a full backup but missing 20 hours of transaction.
I was able to retrieve the current LDF file but not the MDF file.
Thank you.
Post #1536031
Posted Wednesday, January 29, 2014 10:53 AM


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 @ 9:22 AM
Points: 40,632, Visits: 37,094
What recovery model is the database in?


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 #1536041
Posted Wednesday, January 29, 2014 11:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 1:05 PM
Points: 4, Visits: 6
The recovery model is Full.
Post #1536050
Posted Wednesday, January 29, 2014 11:41 AM


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 @ 9:22 AM
Points: 40,632, Visits: 37,094
Then you may be able to hack-attach the database and take a tail-log backup.

http://www.sqlskills.com/blogs/paul/disaster-recovery-101-hack-attach-a-damaged-database/
http://www.sqlskills.com/blogs/paul/disaster-recovery-101-backing-up-the-tail-of-the-log/



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 #1536065
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse