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 2008 Forums
 SQL Server Administration (2008)
 taillog backup

Author  Topic 

maulik318
Starting Member

1 Post

Posted - 2015-01-14 : 00:10:53
Hi All,

I am just implementing a backup strategy on our database server . The previous/ current setup is full back up at midnight and t-backup every half hour.

Company policy allow to lose 30 min work

In case of disaster if i ever wanted to rebuild the db then I do not have to have tail log to restore db . ALl I have to do is to get last full bkup and all tbackup and restore in sequence.

Please correct me if I am wrong.

Cheers,

M

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2015-01-14 : 01:50:40
The cleanest method of recovering is the last valid backup. If the Recovery Model is Full , then RESTORE the last valid backup.
If LOG backups are maintained – then a) backup the tail (assuming db is still available)b) RESTORE the valid backup with NO RECOVERY , c) Restore the Log files d) Restore the tail
The tail-log backup captures any log records that have not yet been backed up.It keeps the work loss to a minimum and improves the recovery point
But, for example, you've completely lost the database, then steps b) and c) are the main points. You don't need the tail log backup


Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -