November 5, 2003 at 9:33 am
I have a client that wants to replicate part of a database during the day and copy the whole database at night.
Any recommendations as to the best way ?
We have thought of using two replications, 1 partial during the day and a full one overnight or to replace overnight one with a backup/restore scenario.
Any advice on best practice would be appreciated.
November 10, 2003 at 10:32 am
More information may be helpful...
Is the data the same during the day as it at night? If so, doing it at night makes no sense to do because transactional replication will be current any way.
If it is different, I would suggest a transaction replication during the day and then the different tables in a snapshot method in the evening.
How big is the db? I would try to convince to do all tables in transactional replication if the data isn't too much.
Remember this when a developer tells you it will just be temporary. Temporary = Permanent.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply