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


SSMS & Database snapshot


SSMS & Database snapshot

Author
Message
Hardy21
Hardy21
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

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

Thanks
Henrico Bekker
Henrico Bekker
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7754 Visits: 5016
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?

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
pitvax
pitvax
Old Hand
Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)

Group: General Forum Members
Points: 329 Visits: 156
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ø
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3755 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
SSCarpal Tunnel
SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

Group: General Forum Members
Points: 4336 Visits: 6240
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ø
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3755 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
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39416 Visits: 9291
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.
Tom Thomson
Tom Thomson
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26507 Visits: 12506
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 (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)

Group: General Forum Members
Points: 145 Visits: 349
I too Choose "It Depends" Answer and got it wrong
Ninja's_RGR'us
Ninja's_RGR'us
SSC Guru
SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)

Group: General Forum Members
Points: 69933 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