May 19, 2011 at 11:22 am
If you use snapshot replication, then I don't think identity columns matter becuase all the data at the subscriber gets dropped & repopulated.
Yes, the folder contains actual data during replication.
May 19, 2011 at 11:48 am
Thanks for the reply...
If ReplData folder contain actual data that means I need to have enough space on disk...I guess all tables to be replicated will make up appx 30 GB. Do I need 30 GB more space on that drive or less?
May 19, 2011 at 11:52 am
Do a test with a smaller amount of data to see what happens
May 19, 2011 at 12:19 pm
Sure... We use windows authentication for all the servers. Do I need to make any security considerations for that?
May 19, 2011 at 12:34 pm
I think that whatever account is running SQL Services would also need permissions to the folder .... It's been a while since I've set up replication though.
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply