Tail backup

Question

Tail backup

HBK_4700

SSCrazy Eights

Points: 8932
More actions
November 10, 2009 at 5:59 pm

#212267

In what circumtances can we recover the database to point of time failure?
I mean can we take the tail backup in every case(eg:-database is offline)

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 1

Tail-log backup

A tail-log backup is a transaction log backup that includes the portion of the log that has not previously been backed up (known as the active portion of the log). A tail-log backup does not truncate the log and is generally used when the data files for a database have become inaccessible but the log file is undamaged.

MJ

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 2

Tail-log backup

A tail-log backup is a transaction log backup that includes the portion of the log that has not previously been backed up (known as the active portion of the log). A tail-log backup does not truncate the log and is generally used when the data files for a database have become inaccessible but the log file is undamaged.

MJ

HBK_4700 SSCrazy Eights Points: 8932 More actions · Answer 3

Can we take tail tlog backup even when db is offline/damaged/correpted

Paul White SSC Guru Points: 150467 More actions · Answer 4

chk2009 (11/10/2009)
Can we take tail tlog backup even when db is offline/damaged/correpted

Yes. Tail Log Backups

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

HBK_4700 SSCrazy Eights Points: 8932 More actions · Answer 5

Paul White (11/10/2009)
chk2009 (11/10/2009)
Can we take tail tlog backup even when db is offline/damaged/correpted
Yes. Tail Log Backups

Thanks for your reply:-)

How can we do that, can you pls explain me in detail, which command to use

Paul White SSC Guru Points: 150467 More actions · Answer 6

chk2009 (11/10/2009)
Thanks for your reply:-)
How can we do that, can you pls explain me in detail, which command to use.

It's all documented in the link I provided before. Just click on the words 'Tail Log Backups'... 😉

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 7

Paul White (11/10/2009)
chk2009 (11/10/2009)
Thanks for your reply:-)
How can we do that, can you pls explain me in detail, which command to use.
It's all documented in the link I provided before. Just click on the words 'Tail Log Backups'... 😉

It seems likely to me that the OP is in a serious bind here. If he cannot read that article and do what is necessary I highly recommend he/she get some help onboard to assist in the recovery. Actually they probably ought to do that regardless. 😎

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

chk2009 (11/10/2009)
Can we take tail tlog backup even when db is offline/damaged/correpted

Providing the log is available, yes. If the log is damaged/missing then no. If it's just the mdf/ndf files that are damaged/missing/corrupt then yes.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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