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 ««12

Recovery using .ldf file in sql server 2005 Expand / Collapse
Author
Message
Posted Friday, June 11, 2010 8:48 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:48 PM
Points: 23,015, Visits: 31,536

Nevermind, Gail responded before I could find the reference below.

You might, might, be able to attempt a tail log backup of the database. Check this out: http://msdn.microsoft.com/en-us/library/ms179314.aspx.

Other than that, not sure if you will be able to recover since the last full backup.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #936089
Posted Friday, June 11, 2010 8:52 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 @ 4:32 PM
Points: 42,458, Visits: 35,518
beejug1983 (6/11/2010)
Command run successfully, do I need to restore full backup then all log backups ?


Yes, restore the full backup from thursday WITH NORECOVERY, then restore all log backups (I assume just this one that you took now) in sequence. All but the last one should have the WITH NORECOVERY option.



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 #936091
Posted Friday, June 11, 2010 9:05 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 9:02 PM
Points: 274, Visits: 1,464
Thanks Gail, your efforts saved me from big problem. Thank you very much.
Post #936103
Posted Friday, June 11, 2010 9:15 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:48 PM
Points: 23,015, Visits: 31,536
May I suggest that you start running scheduled T-LOG backups? This will help manage the size of the transaction log and make database recovery a bit easier.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #936112
Posted Friday, June 11, 2010 10:31 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 9:02 PM
Points: 274, Visits: 1,464
Thanks for your reply.
Post #936169
Posted Monday, February 27, 2012 4:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, March 10, 2012 8:14 AM
Points: 1, Visits: 6
Hi,

I came across this situation when sql bak files were corrupt and I was unable to access the database present as backup file. Got stuck while accessing database.

thanks to systools sql backup recovery, it helped me get back access to the backup system of SQL Server.

Christina
Post #1258143
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse