Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KatrinaBlue
Starting Member
3 Posts |
 Posted - 2009-07-09 : 12:38:16
|
| We are evaluating transactional replication as a possible high availability solution, and I have been experimenting with the restore from backup feature and have it working in a basic fashion, but I have a few questions.1) If we use transactional replication for high availibility we plan on only replicating a few high volume tables. This means we'll need to be able to sync from a fresh backup every day in order to pick up miscellaneous changes outside of our set of replicated articles. What would be the best way to accomplish this daily resync using backup/restore?2) When we create a subscription it needs to be done from script. In the script we reference the .bak file that was used for the restore. How does the replication engine use the backup file? Can it be used to resynchronize the database? Here is a sample script that I used:exec sp_addsubscription @publication ='AcctTransactions', --your pub name here @subscriber='TCE-Backup', --subscriber server name @destination_db='PCP', @sync_type = 'initialize with backup', @backupdevicetype = 'disk', @backupdevicename = 'D:\ReplicationSnapShots\PCPReplication.bak'3) If we're initializeing from backup, then how does the SnapShot agent and SnapShot folder affect replication? Do I still need to make sure thefolder permissions are properly declared? Can I use the SnapShot agent to resynchronize the database?Thanks for your help. I've scanned this forum and the internet but I haven't found anything yet that helps me understand how resynchronization is done when transactional replication is initialized from backup.Katrina |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-07-10 : 09:47:32
|
| First of all Transactional Replication is not High Availability Solution.Also there is nothing to do snapshot in Backup/Restore approach,Your log reader agent will pick up the changes and apply to subscribers. |
 |
|
|
|
|
|
Transactional Replication - Restore From Backu