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

SSMS & Database snapshot Expand / Collapse
Author
Message
Posted Thursday, December 2, 2010 9:38 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:27 AM
Points: 1,130, Visits: 1,390
Comments posted to this topic are about the item SSMS & Database snapshot

Thanks
Post #1029630
Posted Thursday, December 2, 2010 10:26 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:39 AM
Points: 1,880, Visits: 2,846
I beg to differ.
Yes, ok, you cant by default right click and select Create (although there is a very nifty add in available to do this).
But what about creating a snapshot by using t-sql IN SSMS?

And yes, I read the part on the reference link:
Note
SQL Server Management Studio does not support the creation of database snapshots.


This question was 2 sided, and don't think FALSE is 100% correct.
Comments?


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1029644
Posted Friday, December 3, 2010 1:08 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 23, 2014 7:30 AM
Points: 317, Visits: 153
I am agree with Henrico.

In SQL Books Online in the section 'How to: Create a Database Snapshot (Transact-SQL)'you can find that: ...
... The only way to create a snapshot is to use Transact-SQL

But SSMS can helps you to create/run/debug T-SQL code xor...? Therefore I am also meaning that this question has no definite answer. In my opinion 'It depends' seems to be most correct answer.


__________________________________
Standing on the shoulders of giants ...
Post #1029679
Posted Friday, December 3, 2010 2:28 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 7:10 AM
Points: 1,869, Visits: 3,457
I agree with the other posters. I hot the answer correct because I assumed that the author was thinking of the "create database wizard"/GUI part in SSMS, but as the other posters has stated, you can execute T-SQL in SSMS and therefor you can create a snapshot database.
Post #1029702
Posted Friday, December 3, 2010 2:43 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 1,594, Visits: 5,633
I disagree. I think it's being a bit nitpicky to say that "Oh, you can run T-SQL code in SSMS so you can therefore create database snapshots using it". Besides, the question wasn't "Can you create a database snapshot in SSMS?", it was "Does SSMS support creating database snapshots?", which has a slightly different emphasis IMHO.
Post #1029708
Posted Friday, December 3, 2010 2:51 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 7:10 AM
Points: 1,869, Visits: 3,457
I disagree with you paul :)

I don't see any real difference in the two different wordings you present.
The "confusing" part of the question was the "It depends" option. "It depends" should probably be the correct answer since the question does not clearly state that it is talking about the SSMS GUI part.
So "it depends" on how I interpret the question. Questions should be clear and concise, and I think this question failed at this a little bit, especially with the "It depends" option.
Post #1029714
Posted Friday, December 3, 2010 4:22 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 8:54 AM
Points: 5,579, Visits: 6,363
T-SQL is required to create the snapshot, but how many people create snapshots using jobs or SSIS packages? Most people open up SSMS to do it, ergo, the common perception (despite the Microsoft article) is that SSMS does support Snapshots because you have to use a query window to do it.

It seems to me that this question is that it was picked out of a Microsoft article without the author understanding what that comment from the KB article meant. I say this because the author didn't bother to add additional explanation. Just "Look at Microsoft's KB article." Microsoft has posted numerous KB articles, books, and other items with erroneous information before. Most people know this. Therefore, relying on one KB to state the case is a little like a lawyer going into court and saying "You need to rule in my favor because I read a book." to the judge.

If the author had provided a more complete explanation for this question, aside from the KB article, I would feel like this was less of an attempt to one-up people and more of an honest quiz question.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1029745
Posted Friday, December 3, 2010 5:17 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 7,742, Visits: 9,491
I think the right answer is "it depends". It depends on what you mean by "supports the creation of database snapshots". The MS documentation says SSMS doesn't, which implies one meaning for that phrase. Most people who create database snapshots use SSMS, so it's pretty clear that in some real sense SMSS does.

So here we have a case with rotten unclear/ambiguous documentation from MS (they could easily have made a clear, unambiguous, and accurate statement like "SMSS supports creation of database snapshots only through the use of T-SQL", or "SMSS provides no wizard or other GUI to obviate the need to use T-SQL when creating database snapshots", but they didn't.

I'm inclined to think that the question author either read the MS documentation without realising what it meant or intended this as a trick question.


Tom
Post #1029772
Posted Friday, December 3, 2010 5:20 AM
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
I too Choose "It Depends" Answer and got it wrong
Post #1029776
Posted Friday, December 3, 2010 5:47 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Monday, September 22, 2014 6:13 AM
Points: 20,578, Visits: 9,618
janki (12/3/2010)
I too Choose "It Depends" Answer and got it wrong



Me 2... it depends on the sql server version as well which was not specified in the question. So true and false were not 100% certain there along with the scripting point made many times over.
Post #1029795
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse