Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Replication Process

Author  Topic 

scelamko
Constraint Violating Yak Guru

309 Posts

Posted - 2007-03-30 : 08:33:34
Guys,

I am trying to replicate the production data (25GB database) on to a backup server. The snapshot agent is scheduled to
run at 11pm and replication is set to run at 12am.

What I am worried if the snapshot process will slow down the production database drastically and if that is the case what kind of replication - Merge, transaction would optimize the replication replication.

Any suggestions/inputs would help.

Thanks
   

- Advertisement -