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 12345»»»

Database Snapshot Expand / Collapse
Author
Message
Posted Monday, November 8, 2010 8:22 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 8, 2012 7:53 AM
Points: 101, Visits: 349
Comments posted to this topic are about the item Database Snapshot
Post #1017577
Posted Tuesday, November 9, 2010 12:25 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:29 AM
Points: 12,945, Visits: 10,716
Thanks for the question. Learned something today.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1017638
Posted Tuesday, November 9, 2010 1:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:36 PM
Points: 6,002, Visits: 8,267
Nice, easy question.

I was wondering about the inclusion of the "none of the above" option. Was this just a joke from the question author, or will people actually choose this answer? (at this time, none have - 56% True, 44% False, 0% None of the above).



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1017648
Posted Tuesday, November 9, 2010 1:33 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 12:53 AM
Points: 2,529, Visits: 2,402
Hugo Kornelis (11/9/2010)
Nice, easy question.

I was wondering about the inclusion of the "none of the above" option. Was this just a joke from the question author, or will people actually choose this answer? (at this time, none have - 56% True, 44% False, 0% None of the above).

You should wait the end of day!
Post #1017659
Posted Tuesday, November 9, 2010 1:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 6:42 PM
Points: 205, Visits: 1,015
it is all recovery models support database snapshot
Post #1017665
Posted Tuesday, November 9, 2010 1:48 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:52 AM
Points: 1,589, Visits: 5,628
Hugo Kornelis (11/9/2010)
I was wondering about the inclusion of the "none of the above" option. Was this just a joke from the question author, or will people actually choose this answer? (at this time, none have - 56% True, 44% False, 0% None of the above).


Maybe an attempt to introduce trinary logic? Or should the third option have been NULL?
Post #1017667
Posted Tuesday, November 9, 2010 2:03 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 12:53 AM
Points: 2,529, Visits: 2,402
Maybe an attempt to introduce trinary logic? Or should the third option have been NULL?

Please, do not start a discussion about NULLs.
Post #1017675
Posted Tuesday, November 9, 2010 2:52 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, September 8, 2014 5:11 AM
Points: 898, Visits: 601
Nice question! It made me do some reading-up on a feauture I've never used so far.
Allways good to refresh those areas once in a while.
Really like the "none of the above" answer, and will chck back to see if someone actually checked that at the end of the day.


Peter Rijs
BI Consultant, The Netherlands
Post #1017695
Posted Tuesday, November 9, 2010 3:03 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:20 AM
Points: 969, Visits: 691
I can't believe people have actually clicked on "None of the above"

Hope this helps,
Rich



Post #1017703
Posted Tuesday, November 9, 2010 3:25 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299
Hugo Kornelis (11/9/2010)
Nice, easy question.

I was wondering about the inclusion of the "none of the above" option. Was this just a joke from the question author, or will people actually choose this answer? (at this time, none have - 56% True, 44% False, 0% None of the above).

I'm one of those that selected None of the Above. That was because it has nothing to do with recovery models. The model, master, and tempdb databases are prohibited from having snapshots. That, in my opinion, means that "True" cannot be the correct answer to this question and I already know that "False" was wrong. The only other option was "None of the Above" which I thought would mean "It depends on which database."
Post #1017720
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse