Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Snapshots Expand / Collapse
Author
Message
Posted Thursday, January 15, 2009 11:20 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:03 PM
Points: 31,276, Visits: 15,728
Comments posted to this topic are about the item Database Snapshots






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #637751
Posted Friday, January 16, 2009 7:33 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:38 PM
Points: 2,625, Visits: 4,021
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."

Post #638062
Posted Friday, January 16, 2009 8:26 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:24 AM
Points: 1,916, Visits: 1,703
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
Post #638138
Posted Friday, January 16, 2009 8:29 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 10, 2014 12:05 PM
Points: 3,969, Visits: 3,648
Yes, seems to be some conflicting information in BOL.
Post #638143
Posted Friday, January 16, 2009 8:32 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:44 PM
Points: 20,792, Visits: 32,703
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.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #638149
Posted Friday, January 16, 2009 8:37 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 10, 2014 12:05 PM
Points: 3,969, Visits: 3,648
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.
Post #638158
Posted Sunday, January 18, 2009 12:38 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, May 13, 2013 5:16 AM
Points: 51, Visits: 33
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. " [color=#4B0082][/color]
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 [color=#8B0000]CAN USE[/b[/color]]create database snapshots?" or was it meant to be "In which editions of SQL Server 2008 [color=#8B0000][b]"CAN USERS"[/color] create database snapshots?" . May be that's where the answer lies
Post #638871
Posted Sunday, January 18, 2009 8:53 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:03 PM
Points: 31,276, Visits: 15,728
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #638925
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse