January 31, 2011 at 6:40 pm
Hi All,
In maximum interviews we get the below question:
We have a backup scenario, every week Sunday 2AM full backup, daily differential backup at 2AM, and log backups for every 2 hours.
We have latest log backup at 6AM and database crashed at 6:15AM.
How can you recover it without data loss?
I always says if log is accessible will take tail log backup and will recover it.
Is that correct answer or do we have any other option for it?
Thank You.
Regards,
Raghavender Chavva
January 31, 2011 at 8:31 pm
You could also explain the actual restore steps you would take, to give a more complete answer.
January 31, 2011 at 11:55 pm
Just give more detail about your backup process:smooooth:
NEVER NEVER EVER GIVE UP;-)
February 1, 2011 at 6:30 am
If I were running the interview I'd want to hear a lot more than just that you'd taken the tail backup. I'd want to know which backups you had to access and how many of them there would be to get us back on our feet. I'd also expect a little bit of detail, not syntax mind you, that's what BOL is for, on how you would use these backups to do the recovery.
It's a question to demonstrate knowledge. Dig down, start talking until someone tells you to stop.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 2, 2011 at 7:25 am
Grant Fritchey (2/1/2011)
If I were running the interview I'd want to hear a lot more than just that you'd taken the tail backup. I'd want to know which backups you had to access and how many of them there would be to get us back on our feet. I'd also expect a little bit of detail, not syntax mind you, that's what BOL is for, on how you would use these backups to do the recovery.It's a question to demonstrate knowledge. Dig down, start talking until someone tells you to stop.
Sorry, I didn't get you?
Can you please elaborate it ?
Thank You.
Regards,
Raghavender Chavva
February 2, 2011 at 7:42 am
Raghavender (2/2/2011)
Grant Fritchey (2/1/2011)
If I were running the interview I'd want to hear a lot more than just that you'd taken the tail backup. I'd want to know which backups you had to access and how many of them there would be to get us back on our feet. I'd also expect a little bit of detail, not syntax mind you, that's what BOL is for, on how you would use these backups to do the recovery.It's a question to demonstrate knowledge. Dig down, start talking until someone tells you to stop.
Sorry, I didn't get you?
Can you please elaborate it ?
I'm not going to give you a good answer to this one, sorry.
You should be able to talk about the details of restoring a database to a point in time. If you don't know how to do that, take a look at this article[/url]. It'll get you started.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 2, 2011 at 10:46 pm
1) First you should explain them very clearly when database was crashed we required whatever you have the latest Backups Like Recent Full Backup, Recent Diff Backup & Tail/Tran Log Backup.
2) Explain the Restoring process step by step.(explain about the Backup states like Norecovery & Recovery).
i think already you aware of this Concepts.
explain the Concept confidently. They will check candidate confidence level.
Be confident & get the success
All the Best
Subha
DBA
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply