How to create a SQL Server replication using DB backup?

Question

Hello,

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

Answer 1

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.

Answer 2

Thanks, is there any online document for my reference. I would like to know more detail about how to create the replica using backup and restore.