SQL 2005 added the option to do exactly what you're looking to do:
initialize from backup. Generally, the steps are:
1) Create publication and add articles
2) Create backup (this can be your normal daily backup if space is a
3) Restore backup to subscriber (don't delete that backup file yet;
you need it for step 4)
4) Add the subscription to the publication (calling sp_addsubscription
with the @sync_type = 'initialize with backup' and provide the
relevant details for your backup file)
One thing to watch out for is making sure that the distribution
retention is set sufficiently high so that you have time to ship the
backup file and restore it before transactions start to roll off. You
can either set the minimum retention or you can disable the
distribution cleanup job while you're doing your work. Good luck!
Post by sql hunter
I am assigned to do a transactional replication of a large database of size
more than 4 TB and As the snapshot cannot hold the large amount of data I am
looking for better solution like initialize the database from the backup and
then perform the replication.?
Any suggestions,ideas or very good links to do this?