Deep Dive on Initialize from Backup for Transactional Replication

Your rating: None Average: 5 (2 votes)

In my organization, I happened to set up a transactional replication for the whole database (240 gb) on which I ran the snapshot and ended up time out multiple times and gave up that initializing a full database transactional replication is not going to work out for large databases.

Later I came across the following link to setup transactional replication and initializing with backup option.

http://blogs.msdn.com/b/repltalk/archive/2010/03/16/deep-dive-on-initial...

This worked for me :-)

Thanks,
Ganesh