April 17, 2011 at 1:59 pm
Hi All,
Issue :- I am using monthly full backup, daily Diffrencial backup, every 1 hour transaction backup....
If my server will crash at 9:05 PM... how to recover the data.......
Will you help me on this issue......
Thanks in advance....
April 17, 2011 at 2:16 pm
Hi,
first you must restore the last full backup, after this you only need to restore the last differential backup (because it relates to the last full backup not differential backup). Last but not least you need to restore all transaction logs since the last differential backup.
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
April 17, 2011 at 2:20 pm
Hi,
But it will restore upto 9:00 PM, what about my last 5 min backup.....
April 17, 2011 at 2:30 pm
If you are in full recovery model and have log backups then, depending on the type of crash, you may be able to take a tail-log backup and recover the last few minutes of data.
Read up on tail-log backups in SQL books online
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
April 17, 2011 at 2:36 pm
Hi Gilo,
Same thing i told him, i will take a tail-log back up...
He asked me syntax...
tail log backup dbname to dish = 'path'.....this is my answer
but he told me in MS SQL tail log query will not be come..
Can you tell me, what is correct
April 17, 2011 at 2:40 pm
Whoever 'he' is, he's right. That command is completely invalid syntax.
As I said, read up on tail-log backups in SQL books online. There's an entire entry on how and when to run them
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