Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database SnapShot Expand / Collapse
Author
Message
Posted Wednesday, June 25, 2008 9:17 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 22, 2014 2:32 AM
Points: 1,260, Visits: 3,423
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
Posted Wednesday, June 25, 2008 11:35 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, May 4, 2014 7:48 PM
Points: 369, Visits: 217
The computer shouldn't say "You are wrong". It should say, "You are incorrect".
Post #523871
Posted Thursday, June 26, 2008 3:58 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 7:14 AM
Points: 1,274, Visits: 1,983
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

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


Derek
Post #523980
Posted Thursday, June 26, 2008 6:43 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 2:20 PM
Points: 1,510, Visits: 2,702
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
Posted Thursday, June 26, 2008 7:01 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 6, 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
Posted Thursday, June 26, 2008 12:27 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:41 PM
Points: 31,080, Visits: 15,525
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
Posted Thursday, June 26, 2008 12:31 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:22 PM
Points: 2,580, Visits: 3,876
"You are wrong" and "incorrect" mean the same thing. I see nothing wrong or incorrect with saying "you are wrong."

Post #524494
Posted Thursday, June 26, 2008 2:27 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:46 PM
Points: 2,391, Visits: 17,940
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
Post #524557
Posted Thursday, June 26, 2008 3:26 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:17 PM
Points: 5,332, Visits: 25,261
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
Posted Friday, June 27, 2008 3:52 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 3:19 AM
Points: 5,375, Visits: 1,391
Good question ...


Post #524860
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse