Database Backup Types

Question

Database Backup Types

sergey.gigoyan

Ten Centuries

Points: 1223
More actions
December 5, 2019 at 12:00 am

#3699083

Comments posted to this topic are about the item Database Backup Types

Viewing 7 posts - 1 through 7 (of 7 total)

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

Stewart "Arturius" Campbell SSC Guru Points: 72725 More actions · Answer 1

Nice one, sergey

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Jeff Moden SSC Guru Points: 1004600 More actions · Answer 2

Stewart "Arturius" Campbell wrote:

Nice one, sergey

Agreed. I'm not sure why 3 people's votes came out at a low "3". I gave it a 5.

The unexpected good thing about it is that the number of incorrect answers actually show a really bad thing... a lot of people don't know backups deep enough.

To be honest, I think this would make a great pre-interview question.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

webrunner SSC-Dedicated Points: 31991 More actions · Answer 3

Thanks for the instructive question - even though I got it wrong (mistakenly thought choice 4 was true).

-- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

crow1969 Hall of Fame Points: 3001 More actions · Answer 4

Am I the only one who struggled with item 1 thinking "What if the previous log backup was done with COPY_ONLY?"

Stewart "Arturius" Campbell SSC Guru Points: 72725 More actions · Answer 5

crow1969 wrote:

Am I the only one who struggled with item 1 thinking "What if the previous log backup was done with COPY_ONLY?"

COPY_ONLY will not break the backup chain. They can also not be used as a base for further differential backups

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

crow1969 Hall of Fame Points: 3001 More actions · Answer 6

True, but a COPY_ONLY log backup will not truncate the log, which is what I was getting at.

Database Backup Types

Cookies on SQLServerCentral