June 30, 2003 at 1:53 am
Hi,
Present Setup
I have 2 Servers running MS SQL7 SP4, Standard Edition.
Merge Replication is setup, Server 1 as Publisher and Server 2 as its subscriber.
The subscription is setup push from the Server1 to Server2.
It agent is setup to run continuously.
At an instance one Server is Active and other is at standby state.
They can be switched backup and forth to distribute the load. Like Server 1 is online for a week/month
And then Server 2 is online.
New Requirement
I need to implement a new Server for Archiving purpose to minimize the database load on the current 2 servers. There is no operation from midnight to 6.00 am morning, so there should not be problem for running a SP. But I seek to do things at the New archive Server and does not touch much the Current Servers.
The replicated database which has nearly 80 tables, modifying/updating data on daily basis. I want to establish a new Server having hardware RAD-1, for archiving of the data.
So that different reporting can be done on it
Analysis is that
1. 60 tables only got data changes + addition.
2. 20 tables are those which only append data, there is no way to do changes in them.
I want to replicate 60 tables by making a SP which makes a duplicate copy every night on the Archiving Server.
+
I want to transfer all data from the 20 tables which verify the condition (GetDate() – 3),to the Archive Server.
Please guide….., Need to have your ideas
Thanks..
July 3, 2003 at 10:19 am
I dont understand - are you trying to archive data or create a second reporting server?
Andy
July 4, 2003 at 3:19 pm
Hi,
Want to minimize load on the production Serves, and have a one dedicated PC for different sort of Report development/generation....
July 4, 2003 at 5:07 pm
If you just need a copy, why not go with snapshot replication? It handles all the details for you and keeps it simple, more so than writing your own code to move data.
Andy
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply