March 16, 2011 at 1:01 pm
We have routine backup of our databases, like weekend a full backup, daily one time diffirential backup, and 3-5 hours of transaction backup.
My question is when a full backup succeeded, but a diffrential back up failed, 3 transactions are OK. can I restore the database, by just using full backup, and 3 transactions backup?
March 16, 2011 at 1:16 pm
It is not possible to apply a transaction log backup:
* Unless the database or differential database backup preceding the transaction log backup is restored first.
* Unless all preceding transaction logs created since the database or differential database was backed up are applied first.
---------------------------------------------------------------------------------------
It begins by taking the first step.
March 16, 2011 at 1:31 pm
annasql (3/16/2011)
My question is when a full backup succeeded, but a diffrential back up failed, 3 transactions are OK. can I restore the database, by just using full backup, and 3 transactions backup?
Providing those are the only three log backups since the full backup, yes
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 16, 2011 at 2:30 pm
Thank you, both. I understand GilaMonster's post, Yes, that are the only 3 transactions backup.
We have also a senoria like this:
We copied a datatbase from production server to a testing server. The testing server is also having scheduled full, diffrential, trans log backup.
Then developer does something on the server for a couple of days. Then he did something wrong and want to restore the database to something to the most recent day 12 o'clock.
Then we found the full backup on the testing server failed over the weekend. But later differential, and transaction log backup succeeded.
My question is: I would do a restore, but since I don't have the full backup, can I use the backup copy I moved from another server to the testing server -the copy I used to refresh the database, and then use the differentail and transaction backup after that?
Thanks
March 17, 2011 at 12:52 am
Nope, you cann't as full backup of the same database whose diff/log backup is there with you now is required.
HTH!
MJ
March 17, 2011 at 1:56 am
Was there no other full backup of the test server? If not, that may actually work, the diff would not have succeeded if there wasn't a full backup around. Try it, no guarantees.
Otherwise, check and see if there was another full backup taken of the test database, even an ad-hoc one. The diff will be based on the last full backup of the DB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply