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

Recover database using LDF File Expand / Collapse
Author
Message
Posted Friday, October 4, 2013 11:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, October 5, 2013 7:19 AM
Points: 1, Visits: 7
Hi All,

I have Database in SQL Server 2005 and database is in Full recovery mode.

accidentally i trucate some of the tables which should be truncate from other database.

is there any way to recover data or full database using ldf file.

Please help me.

Thanks in Advance
Post #1501720
Posted Friday, October 4, 2013 12: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 @ 3:09 PM
Points: 40,172, Visits: 36,560
Restore your last full backup as a new database (restore with norecovery), restore all log backups taken up to the point of the accident WITH STOPAT and specify a time just before the accident. If the accident was after the last log backup, then take another log backup off the database with the missing tables and restore that WITH STOPAT and specify a time just before the accident.


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

Add to briefcase

Permissions Expand / Collapse