开发者

How to create a SQL Server replication using DB backup?

开发者 https://www.devze.com 2022-12-16 18:55 出处:网络
I am trying to build a DB replication using MSSQL 2005.Both publisher and subscriber are SQL Server database.I know I can create subsriber database from the snapshop of publisher.However, snapshot age

I am trying to build a DB replication using MSSQL 2005. Both publisher and subscriber are SQL Server database. I know I can create subsriber database from the snapshop of publisher. However, snapshot agent will put开发者_运维知识库 the share lock on publisher DB, which is a production database. Is there any way I can build a replication and initialize subscriber db from restoring a DB backup instead of running snapshot agent?

Thanks


You can. Here are some things to be aware of:

  • You can use profiler to see the scripts that are running at any given time (use it while performing a backup and a restore)
  • If you are using a restore to copy a database, once its finished, any users that were tied to the backed up database will have to be recreated.
0

精彩评论

暂无评论...
验证码 换一张
取 消