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.
| 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 tailThe 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 pointBut, for example, you've completely lost the database, then steps b) and c) are the main points. You don't need the tail log backupJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
taillog backup