May 19, 2011 at 10:39 am
Hi Experts,
I Need to create Snapshot Replication from SQL 2000 (SP4) to SQL 2005 (SP2). I need to Publish 80 tables from one database and 20 tables from another database; they all will be going to the same subscriber database on another server. New snapshot needs to be generated and applied every 8 hours. Few tables have identity column. Subscriber database already exists and the tables are also created.
Can someone please provide me best practices/suggestions/dos and dont's for configuring replication in this scenario?
One question, When Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ReplData folder is created, Does that folder carry actual data? Do I need to share that folder?
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 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply