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, November 20, 2014 3:44 AM
Points: 1,260, Visits: 3,424
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: Thursday, December 11, 2014 3:10 AM
Points: 1,274, Visits: 1,987
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: Wednesday, December 17, 2014 5:23 AM
Points: 1,522, Visits: 2,731
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: 2 days ago @ 3:11 PM
Points: 31,368, Visits: 15,837
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: Friday, December 19, 2014 9:53 AM
Points: 2,667, Visits: 4,091
"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: Friday, December 19, 2014 4:08 PM
Points: 2,396, Visits: 18,069
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: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
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: Monday, December 15, 2014 4:15 AM
Points: 5,474, Visits: 1,402
Good question ...


Post #524860
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse