Interview Questions -BackUp

Question

Post reply

Interview Questions -BackUp

karthik M

One Orange Chip

Points: 29139
More actions
December 11, 2007 at 1:04 am

#119740

Hi Experts,
Can someone give me the list of interview questions for DATABASE BACKUP ?
Inputs are highly appreciable.
karthik

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Chandra Sekhara Vyas Dhara SSChampion Points: 10207 More actions · Answer 1

1) Explain different types of BACKUPs avaialabe in SQL Server?

2) Given a particular scenario, how would you go about choosing a backup plan?

Larry Taylor Old Hand Points: 326 More actions · Answer 2

How would you go about verifying that your backup/restore plan a.) works and b.) meets restore time and data loss SLA's?

Kevin Brennan Right there with Babe Points: 738 More actions · Answer 3

The question that I always ask is:

Given that we take a full backup once a week and diff backups every day and transaction log backups every 15 mins and say we have a problem at 11 am on a wednesday what is restore sequence need to restore the database to say 10:59 am.

CodeMinkey

Brandie Tarvin SSC Guru Points: 173045 More actions · Answer 4

Where can backup files be saved? What native tools does SQL Server provide for creating backups? How would you access those tools? How would you retrieve the backups if needed?

You might also want to consult with BOL. There are a couple of new features on backups (like CheckSum) that you might consider as good interview questions. And you might consider making someone sit down and script out a backup device or backup task.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Vivien Xing SSChampion Points: 12297 More actions · Answer 5

How do you plan a database backup?

This is an open question. Depends on how much s/he knows and how much considerations from both database and business perspectives.

thecosmictrickster@gmail.com SSChampion Points: 10386 More actions · Answer 6

Explain how a differential backup works. I had that one in my last interview.

Scott Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare

Steve Jones - SSC Editor SSC Guru Points: 736063 More actions · Answer 7

What are the problems with a striped backup? How do problems occur in Management Studio/EM with striped backups?

In 2005, how can I make a copy of a backup automatically in a 2nd location.

Suresh B. SSC-Insane Points: 22986 More actions · Answer 8

How do you backup without affecting the maintenance plan?

Brandie Tarvin SSC Guru Points: 173045 More actions · Answer 9

Can you backup while the database is online? If so, how?

Believe it or not, people actually ask that question (though I've never heard it in an interview).

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Karthik-214069 SSChasing Mays Points: 631 More actions · Answer 10

[font="Verdana"]Is it possible to take a differential backup when a database is in simple recovery?[/font]

Brandie Tarvin SSC Guru Points: 173045 More actions · Answer 11

Funny you should ask that... Just Tuesday, we had an article in the newsletter about that question.

See the below link:

http://www.sqlservercentral.com/articles/Administration/61591/

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

manoj-356326 SSC Rookie Points: 39 More actions · Answer 12

Differential backup is a backup between 1 and 2 full backup. It means whatever changes you have made on the DB It will update on the Differntial backup. Generally will plann in the corporate sector full DB backup should be once in a week and every day differntial backup and as per the business criticality you can choose the Tlog backup schedule.

Thanks,

Manojs