Thursday, February 11, 2010

How To Take Tail Log Backup


Tail log backup is like any log backup, a tail-log backup is taken by using the statement BACKUP LOG. You can take a tail-log backup in the following situations: 

If the database is online:
before starting a restore sequence, back up the tail of the log using WITH NORECOVERY whenever the next action you plan to perform on the database is a restore operation:  

BACKUP LOG database_name TO WITH NORECOVERY
(To avoid an error, the NORECOVERY option is necessary) 

If the database is offline and does not start:
Try to take a tail-log backup. Because no transactions can occur at this time, using WITH NORECOVERY is optional. If the database is damaged, use either WITH CONTINUE_AFTER_ERROR or WITH NO_TRUNCATE. 

BACKUP LOG database_name TO [WITH { CONTINUE_AFTER_ERROR | NO_TRUNCATE } 

We recommend that you avoid using NO_TRUNCATE, except when the database is damaged. If the database is damaged, for example, if the database does not start, a tail-log backup succeeds only if the log files are undamaged, the database is in a state that supports tail-log backups, and the database does not contain any bulk-logged changes.
how to take tail log backup. how to take taillog backup. data base administrator. microsoft database administrator. sql questions and answers. interview questions for servers. database administrator interview questions. NO_TRUNCATE. notruncate. WITH CONTINUE AFTER ERROR. backup log database. what is database. what is log backup. what is database. how to take backup in sql server 2012. tail log backup in sql server 2008 r2. tail log backup in sql server 2005. taillog backup in sql server.

0 comments:

Post a Comment