Database Snapshots

Question

Post reply

Database Snapshots

Steve Jones - SSC Editor

SSC Guru

Points: 736150
More actions
January 15, 2009 at 11:20 pm

#63592

Comments posted to this topic are about the item Database Snapshots

Viewing 8 posts - 1 through 7 (of 7 total)

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

OCTom SSChampion Points: 11785 More actions · Answer 1

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:

ben.d Hall of Fame Points: 3364 More actions · Answer 2

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

Cliff Jones SSChampion Points: 10547 More actions · Answer 3

Yes, seems to be some conflicting information in BOL.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

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.

Cliff Jones SSChampion Points: 10547 More actions · Answer 5

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.

DangerMouseKaBoom SSC Enthusiast Points: 191 More actions · Answer 6

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

Steve Jones - SSC Editor SSC Guru Points: 736150 More actions · Answer 7

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.