我需要将数据库从SQL Server实例测试服务器传输到群集的生产环境。但是，SQL Server不允许我们使用备份/还原从单个实例到群集执行此操作。我在这里谈论的是Microsoft CRM复杂数据库。

非常感谢帮助。

解决方案

看看Microsoft SQL Server数据库发布向导：

SQL Server Database Publishing Wizard
  enables the deployment of SQL Server
  databases into a hosted environment on
  either a SQL Server 2000 or 2005
  server. It generates a single SQL
  script file which can be used to
  recreate a database (both schema and
  data) in a shared hosting environment
  where the only connectivity to a
  server is through a web-based control
  panel with a script execution window.
  If supported by the hosting service
  provider, the Database Publishing
  Wizard can also directly upload
  databases to servers located at the
  shared hosting provider.
  
  Optionally, SQL Server Database
  Publishing Wizard can integrate
  directly into Visual Studio 2005
  and/or Visual Web Developer 2005
  allowing easy publishing of databases
  from within the development
  environment.

我们不必使用服务器端的组件。客户端的"创建脚本"部分通常就足够了。