Database SnapShot

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Dugi » Database SnapShot

Database SnapShot

Rate Topic

Display Mode

Topic Options

Author

Message

Dugi

Posted Wednesday, June 25, 2008 9:17 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252, Visits: 3,367

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/

Post #523828

umailedit

Posted Wednesday, June 25, 2008 11:35 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 11:54 PM
Points: 367, Visits: 211

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

Post #523871

Derek Dongray

Posted Thursday, June 26, 2008 3:58 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:04 AM
Points: 1,342, Visits: 1,946

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" :D

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 Sad

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

Derek

Post #523980

WILLIAM MITCHELL

Posted Thursday, June 26, 2008 6:43 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:45 AM
Points: 1,441, Visits: 2,485

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?

Post #524090

Steven Cameron

Posted Thursday, June 26, 2008 7:01 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, April 06, 2009 1:29 PM
Points: 2,057, Visits: 215

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

Post #524108

Steve Jones - SSC Editor

Posted Thursday, June 26, 2008 12:27 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 11:09 AM
Points: 31,423, Visits: 13,736

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

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #524491

OCTom

Posted Thursday, June 26, 2008 12:31 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 10:28 AM
Points: 2,015, Visits: 2,845

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

Cool

Post #524494

Chad Crawford

Posted Thursday, June 26, 2008 2:27 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 11:22 AM
Points: 2,548, Visits: 17,358

skjoldtc (6/26/2008)

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

Cool

right or wrong, THAT was hilarious.
Chad

Post #524557

bitbucket-25253

Posted Thursday, June 26, 2008 3:26 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 6:52 AM
Points: 5,102, Visits: 20,204

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
Before posting a performance problem please read

Post #524591

Anipaul

Posted Friday, June 27, 2008 3:52 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 4,787, Visits: 1,336

Good question ...

Post #524860

« Prev Topic | Next Topic »

Permissions