June 25, 2008 at 9:17 pm
Comments posted to this topic are about the item Database SnapShot
June 25, 2008 at 11:35 pm
The computer shouldn't say "You are wrong". It should say, "You are incorrect".
June 26, 2008 at 3:58 am
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
June 26, 2008 at 6:43 am
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?
June 26, 2008 at 7:01 am
I hate when I don't read the question correctly. I got my logic flipped when I didn't read "not" allowed.
June 26, 2008 at 12:27 pm
I could see a snapshot on msdb for history purposes or even testing since it's got scheduling/history data.
June 26, 2008 at 12:31 pm
"You are wrong" and "incorrect" mean the same thing. I see nothing wrong or incorrect with saying "you are wrong."
June 26, 2008 at 2:27 pm
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
June 26, 2008 at 3:26 pm
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
June 27, 2008 at 3:52 am
Good question ...
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy