November 4, 2014 at 6:45 am
Hi,
On what situation we will go for tail log backup & point in time restore
Please clarify.
November 4, 2014 at 6:49 am
They are not mutually exclusive.
For example, if you want to restore to a point-in-time after the last back-up, you need to do a tail-log back-up first.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 5, 2014 at 10:02 am
jamessdba (11/4/2014)
Hi,On what situation we will go for tail log backup & point in time restore
Please clarify.
A point in time restore is exactly that, you're restoring a database to a specified point in time, as so
restore database [bob] from disk = '?:\somepath\somefile.bak'
with Stopat = 'yyyy-MM-dd hh:mi:ss'
A tail log backup, if successful, simply allows you to restore a given database to as close to the disaster time as possible.
Note: not all point in time restores will require a tail log backup, it will depend on the PIT you require
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply