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.
精彩评论