开发者

How to create a SQL Server replication using DB backup?

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜