January 15, 2009 at 11:20 pm
Comments posted to this topic are about the item Database Snapshots
January 16, 2009 at 7:33 am
Steve,
Does this link contradict you?
http://msdn.microsoft.com/en-us/library/ms175158.aspx
A quote from it:
"Database snapshots are available only in SQL Server 2005 Enterprise Edition and later versions."
:unsure:
January 16, 2009 at 8:26 am
Steve,
Here is were I got my answer: http://msdn.microsoft.com/en-us/library/ms190677.aspx
SQL Server 2008 Books Online (December 2008)
Creating a Database Snapshot
This topic describes some best practices for creating database snapshots and provides a link to the procedure for creating them.
Any user who can create a database can create a database snapshot.
Important:
Database snapshots, introduced in SQL Server 2005, are available only in the Enterprise editions of SQL Server 2005 and SQL Server 2008.
Thanks,
Ben
January 16, 2009 at 8:29 am
Yes, seems to be some conflicting information in BOL.
January 16, 2009 at 8:32 am
However, the Developers Edition is actually the Enterprise Edition with different licensing. Therefore all the features of the Enterprise Edition are available in the Developer Edition.
January 16, 2009 at 8:37 am
Thanks, that is good information to have. I was just curious to know if that was the correct answer. 77% had it correct so now I know.
January 18, 2009 at 12:38 am
Hello Steve,
Now this question in particular is going to create ALOT of debate.
1.I tried to do some reading before I could answer the question, and what I came up with was stated "Important:
Database snapshots, introduced in SQL Server 2005, are available only in the Enterprise editions of SQL Server 2005 and SQL Server 2008. " from http://msdn.microsoft.com/en-us/library/ms190677.aspx .
What's going on?
2.And was it meant to be "In which editions of SQL Server 2008 CAN USE[/b]create database snapshots?" or was it meant to be "In which editions of SQL Server 2008 "CAN USERS" create database snapshots?" . May be that's where the answer lies
January 18, 2009 at 8:53 am
The typo is being fixed.
The developer's edition is Enterprise with different licensing. It includes all features so you can build applications with them. Developer's Edition cannot be deployed to a production environment, so it isn't often listed with the editions.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy