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: Thursday, July 31, 2014 5:13 AM
Points: 1,262, Visits: 3,420
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,344, 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: Today @ 6:10 AM
Points: 1,506, Visits: 2,680
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 @ 4:05 PM
Points: 33,165, Visits: 15,299
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 @ 12:47 PM
Points: 2,546, Visits: 3,784
"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 @ 12:31 PM
Points: 2,607, Visits: 17,913
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: Today @ 7:50 AM
Points: 5,586, Visits: 24,934
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: Thursday, August 14, 2014 12:26 AM
Points: 5,335, Visits: 1,383
Good question ...


Post #524860
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse