Transaction replication using Backup and Restore

Last Post 08 Apr 2004 03:45 AM by ggopie. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ggopie
New Member
New Member

--
08 Apr 2004 03:45 AM
What is the best method to configure transactional replication, which would cost less downtime on our production database which is the publisher. I have tried the Backup and Restore method which is fast, but I could not get the disributor agent working. IF I use Enterprise Manager and do the regular steps, it locks the tables and any transaction that needs to do any DML is blocked. There is an option Do not lock objects..., Does this means that the tables are not locked during the snapshot?
You are not authorized to post a reply.

Acceptable Use Policy