Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLMark
Starting Member
18 Posts |
 Posted - 2009-01-14 : 11:10:12
|
I'm very very disappointed...  I have to use snapshot but I have known that this feature is available only in Enterprise Edition and Developer Edition (for SQL Server 2005) and in the Enterprise Edition of SQL Server 2008!GRRR....!My questions are:1) Is there an alternative to the snapshots in SQL Server (no TRANSACTION, please refer to this my previous topic for more details - http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=117722)?2) Can I buy a mixed version of SQL Server? Since I cannot sell the Enterprise and Developer Editions to the customers (for commercial reasons...), do you know if it is possible ask to Microsoft to buy a "custom" edition (for example a SQL Server Standard with snapshot inside)? Or this is only "science fiction"?Very, very confused.... |
|
|
revelator
Starting Member
32 Posts |
Posted - 2009-01-14 : 11:18:36
|
| There is no "mixed" version of SQL Server available.Can you not use a full backup of your DB to provide similar functionality to a snapshot?-----------------------------------Waiting for the Great Leap Forwards |
 |
|
|
SQLMark
Starting Member
18 Posts |
Posted - 2009-01-14 : 11:23:08
|
| No ... I prefer to don't use backup because my databases are very expansive (2,3 GB !)...It was very userful to use snapshots because it save only changes. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-14 : 15:41:31
|
| But eventually it will be same size . |
|
|
|
|
|
|
Alternative to the snapshots??