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

Database corrupt Expand / Collapse
Author
Message
Posted Thursday, February 5, 2009 11:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 16, 2009 3:52 AM
Points: 7, Visits: 25
suppose every night i am taking full backup ,every 2 hours taking differnetial backup.every 1 hour taking transcation log backup.

I have transcation log backup up to 01:00PM..but my database is crashed on 01:15PM.How to retrive the 15 Mins Data.
Post #651413
Posted Friday, February 6, 2009 12:01 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 @ 3:52 AM
Points: 42,467, Visits: 35,535
Depends how the DB crashed.

If the log is still accessible and SQL's still running, then you back up the tail of the log (no truncate, no recovery options), and restore that as the last log backup when you restore the database.

If the log is not accessible (say the log drive failed), then you cannot retrieve that last 15 min of data.



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 #651415
Posted Friday, February 6, 2009 12:04 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
The Order goes like this:

Bakcup the Acitve portiong of the log(Tail log)
Recent Full backup(No Recovery)
Recent Differential backup(No Recovery)
Latest Tlog backup(No Recovery)
and finally Tail Backup with STOPAT (Recovery)
Post #651416
Posted Friday, February 6, 2009 12:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 16, 2009 3:52 AM
Points: 7, Visits: 25
Thank you
Post #651417
Posted Friday, February 6, 2009 12:10 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 @ 3:52 AM
Points: 42,467, Visits: 35,535
Krishna (2/6/2009)

and finally Tail Backup with STOPAT (Recovery)


You only need STOPAT if there are some commands in the log that you don't want to restore (for eg a user dropping a table). If there are no such commands, leave out STOPAT and restore the entire log tail.



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 #651419
Posted Friday, February 6, 2009 12:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 16, 2009 3:52 AM
Points: 7, Visits: 25
Bakcup the Acitve portiong of the log(Tail log)-how to take the tail log backup(Command)..........?
Post #651430
Posted Friday, February 6, 2009 12:45 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
n.yarramreddy (2/6/2009)
Bakcup the Acitve portiong of the log(Tail log)-how to take the tail log backup(Command)..........?


BACKUP LOG WITH NO_TRUNCATE

Look in BOL to understand the concept before working on it.
Post #651432
Posted Friday, February 6, 2009 12:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 16, 2009 3:52 AM
Points: 7, Visits: 25
Thank u krishna
Post #651435
Posted Friday, February 6, 2009 2:18 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
My Pleasure!

Please do post if you have any errors, we would be able to help you out
Post #651989
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse