sql server 2008 数据快照的创建

Question

Express Edition (64-bit) 不支持 Database Snapshot。
这个问题该怎么解决？

Answer 1

这个是版本功能限制，Express不能作为发布或者分发的，只能做为订阅方。

Microsoft SQL Server 2008 Express (SQL Server Express) can serve as a Subscriber for all types of replication, providing a convenient way to distribute data to client applications that use SQL Server Express. When using SQL Server Express in a replication topology, consider the following:

• SQL Server Express cannot serve as a Publisher or Distributor.

http://msdn.microsoft.com/en-us/library/ms165686(v=sql.105).aspx

---

Please Mark As Answer if it is helpful.

Answer 2

楼上问的是数据库快照，你回答的牛头不对马嘴。

不过版本功能限制是说对了，只有DataCenter, Enterprise及评估版、开发版支持数据库快照。免费或者便宜的版本，功能当然有限制了，不然贵的版本谁买啊。

---

想不想时已是想，不如不想都不想。

Answer 3

不好意思看错了，当成发布的快照了。

---

Please Mark As Answer if it is helpful.