看看 ^ ]

亲爱的阿米尔，

检查此链接，希望对您有帮助.

^ ]

问候，
AP

Dear Amir,

Check this link, Hope it will help you.

http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/[^]

Regards,
AP

除了提供了 djj55 链接外，请查看以下链接以获取更多信息:
CP:SQL Server 2000-合并复制分步过程 [ ^ ]
实施事务复制 [ MSDN:使用SQL Server实施主从快照复制 [ SQL Server复制 [在服务器之间复制数据 [如何实现双向事务复制 [ ^ ]

查看它们，并确定保留数据库副本的***方法.

Apart from djj55 link provided, look at these to get more info:
CP: SQL Server 2000 - Merge Replication Step by Step Procedure[^]
Implementing Transactional Replication [^]
MSDN: Implementing Master-Subordinate Snapshot Replication Using SQL Server[^]
SQL Server Replication[^]
Copying Data Between Servers[^]
How To Implement Bidirectional Transactional Replication[^]

Have a look at them and decide on the best way to keep a copy of your database.