Database Snapshots

  • Comments posted to this topic are about the item Database Snapshots

  • 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:

  • 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

  • Yes, seems to be some conflicting information in BOL.

  • 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.

  • 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.

  • 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

  • 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 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply