Database corrupt

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Database corrupt

Database corrupt

Rate Topic

Display Mode

Topic Options

Author

Message

n.yarramreddy

Posted Thursday, February 05, 2009 11:56 PM

Forum 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

GilaMonster

Posted Friday, February 06, 2009 12:01 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 37,687, Visits: 29,946

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

maechismo_8514

Posted Friday, February 06, 2009 12:04 AM

Ten 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

n.yarramreddy

Posted Friday, February 06, 2009 12:05 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 16, 2009 3:52 AM
Points: 7, Visits: 25

Thank you

Post #651417

GilaMonster

Posted Friday, February 06, 2009 12:10 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 37,687, Visits: 29,946

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

n.yarramreddy

Posted Friday, February 06, 2009 12:40 AM

Forum 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

maechismo_8514

Posted Friday, February 06, 2009 12:45 AM

Ten 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

n.yarramreddy

Posted Friday, February 06, 2009 12:49 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 16, 2009 3:52 AM
Points: 7, Visits: 25

Thank u krishna

Post #651435

maechismo_8514

Posted Friday, February 06, 2009 2:18 PM

Ten 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 »

Permissions