-
Replication Question.
I am a new DBA and we want to replicate a large (approx 20 gigs) database, from our internal network to our external network. The subscriber database will be read only and will only need to be updated once a week. The published database will have a considerable amount of change between replications.
How should I approach replication? If I do snapshots, that means every time the publisher publishes the snapshot it will have to make a snapshot of the whole database and all that data will have to be transported through our firewall. What are the best options I should look into to minimize the replication process and network traffic?
Which replication model: snapshot, transactional, etc should I consider, or not consider.
Any information is greatly appriciated!
Thanks
Rob
-
I recommend you to do a backup,zip,FTP and restore it the destination server cas' you need it only once a week.
if you like use SQLZIP that will do the compression by itself.
-
I have never heard of SQLZIP, does it come with SQL?
Also how could I automate these steps?
By the way, I am using SQL Server 2000.
-
How fast you need.
My article related to your question is on its way. you will see it in here soon
(in a week)
-
BTW SQLZip is a third party compression software.
www.sqlzip.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|