Database SnapShot

Question

Post reply

Database SnapShot

Dugi

SSCoach

Points: 17998
More actions
June 25, 2008 at 9:17 pm

#183984

Comments posted to this topic are about the item Database SnapShot
============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Viewing 10 posts - 1 through 9 (of 9 total)

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

umailedit SSCrazy Points: 2087 More actions · Answer 1

The computer shouldn't say "You are wrong". It should say, "You are incorrect".

StarNamer SSCrazy Eights Points: 8744 More actions · Answer 2

umailedit (6/25/2008)
The computer shouldn't say "You are wrong". It should say, "You are incorrect".

The computer doesn't say anything. The question setter says "You are wrong" 😀

In my case, I didn't think carefully enough about the reasons:

tempdb can't have snapshots because it's rarely explicitly referenced and a read-only temporary area is pointless.

model is a template, so should be treated as read-only anyway (plus it's never referred to explicitly either).

master contains the description of the structure of all other databases (amongst other things), so a snapshot wouldn't work because it may not describe the structure correctly and hence would be unusable.

The other 3 are really just ordinary databases. Although msdb contains a lot of MS specific stuff such a scheduling info, it's really just an ordinary database.

I missed out on master 🙁

(... Waiting for someone more knowledgeable to correct me ... )

Derek

WILLIAM MITCHELL SSChampion Points: 13766 More actions · Answer 3

I got it wrong, didn't know that creating a snapshot for msdb is not "prohibited" but I have to wonder - what would be the purpose of creating a snapshot for msdb?

Steven Cameron SSCrazy Points: 2903 More actions · Answer 4

I hate when I don't read the question correctly. I got my logic flipped when I didn't read "not" allowed.

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 5

I could see a snapshot on msdb for history purposes or even testing since it's got scheduling/history data.

OCTom SSChampion Points: 11785 More actions · Answer 6

"You are wrong" and "incorrect" mean the same thing. I see nothing wrong or incorrect with saying "you are wrong."

😎

Chad Crawford SSChampion Points: 11610 More actions · Answer 7

skjoldtc (6/26/2008)
"You are wrong" and "incorrect" mean the same thing. I see nothing wrong or incorrect with saying "you are wrong."
😎

right or wrong, THAT was hilarious.

Chad

Ron McCullough SSC Guru Points: 63877 More actions · Answer 8

Darn good question.

Between the database setting of Allow_snapshot_isolation, all the Row versioning techniques / abilities, then throw in the MSDB for good measure. Now I think I know how much I did NOT know about snapshots - their advantages / disadvantages. backing up of a snapshot and on and on and on and on ad nausim.

Again a good question relatively simple, yet a great learning experience

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Anipaul SSC-Insane Points: 24681 More actions · Answer 9

Anipaul

SSC-Insane

Points: 24681

June 27, 2008 at 3:52 am

#835235

Good question ...