The Backup Operator

Question

The Backup Operator

Steve Jones - SSC Editor

SSC Guru

Points: 736255
More actions
October 19, 2016 at 12:15 am

#72655

Comments posted to this topic are about the item The Backup Operator

Viewing 6 posts - 1 through 5 (of 5 total)

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

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 1

Simply, when the backup agent job makes the backups it makes them from the master database context (for example) and not changing the contexts for each of the databases.

So no need to confuse with the db context.

Igor Micev,My blog: www.igormicev.com

Ed Wagner SSC Guru Points: 287026 More actions · Answer 2

Right, unless you miss the context used in the first set of permissions granted. :alien: Need more coffee.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

TomThomson SSC Guru Points: 104773 More actions · Answer 3

Interesting. Good question.

I thought that might be how it is, but was unsure because the permission is assigned to a database user, not to a login, so read up on cross database ownership chaining - and the only conclusions I reached were (i) that documentation is pretty dreadful and (ii) that it looked as if chaining might be required, but also might not, depending on what the documention means and/or what it's left out.

So I convinced myself that my first idea must have been wrong, and thus got it wrong.

Tom

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 4

BWAA-HAAA!! The correct answer isn't actually available on this question. 😉 There is no way that I'd grant a non-DBA the privs to do a direct backup even on a Dev box. :w00t:

--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)

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Thanks for the question.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP