What Is a Tail-Log Backup? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

What Is a Tail-Log Backup?

Author

Topic

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2008-12-30 : 04:38:04

What is the basic purpose of Tail log backup, while i can restore my database with option "Point in time recovery", without selecting tail log backup option ????

ghemant
Starting Member

22 Posts

Posted - 2008-12-30 : 06:59:42

Hi,
Consider a situation where in your database got damaged for some reason and you are yet to begin the emergency restore and it is possible for you to take a T-Log backup (if database is offline and corrupt perform t-log backup using with No_truncate or with continue_after_error) for that damaged database; so this T-Log backup is called Tail Log backup.

Well, when perform Tail Log backup it allows you to recover as much as possible data, you can say it as poin-in-minute recovery and if Tail Log backup is not allowed you can recover your data untill your last T-Log backup.

HTH

Regards
Hemantgiri S. Goswami
http://hemantgirisgoswami.blogspot.com/

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2008-12-30 : 07:22:51

How can i take a t-log backup when a database is offline ?

ghemant
Starting Member

22 Posts

Posted - 2008-12-30 : 07:34:32

You can take t-log using
backup log databasename
to disk='somepath\file'
with no_truncate;
go

OR

backup log databasename
to disk='somepath\file'
with continue_after_error;
go

Regards
Hemantgiri S. Goswami
http://hemantgirisgoswami.blogspot.com/

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2008-12-30 : 07:45:39

Msg 942, Level 14, State 3, Line 1
Database 'databasename' cannot be opened because it is offline.
Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.

ghemant
Starting Member

22 Posts

Posted - 2008-12-30 : 08:15:13

Have you tried both the option!! If yes, that means you are not allowed to take tail log backup and hense you can recover your database upto your lat t-log backup.

hth

Regards
Hemantgiri S. Goswami
http://hemantgirisgoswami.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources