SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSMS & Database snapshot


SSMS & Database snapshot

Author
Message
Hardy21
Hardy21
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1564 Visits: 1399
Comments posted to this topic are about the item SSMS & Database snapshot

Thanks
Henrico Bekker
Henrico Bekker
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3625 Visits: 4331
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?
pitvax
pitvax
Old Hand
Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)

Group: General Forum Members
Points: 321 Visits: 155
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 ...
Nils Gustav Stråbø
Nils Gustav Stråbø
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2433 Visits: 3575
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.
paul.knibbs
paul.knibbs
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2519 Visits: 6232
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.
Nils Gustav Stråbø
Nils Gustav Stråbø
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2433 Visits: 3575
I disagree with you paul Smile

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.
Brandie Tarvin
Brandie Tarvin
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14488 Visits: 8989
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 AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
TomThomson
TomThomson
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14240 Visits: 12197
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

janki
janki
SSC-Enthusiastic
SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)

Group: General Forum Members
Points: 115 Visits: 349
I too Choose "It Depends" Answer and got it wrong
Ninja's_RGR'us
Ninja's_RGR'us
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28787 Visits: 9671
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search