sql server replication: Best technique for Replication -- sql server replication

Best technique for Replication

Rick Rushing
6/14/2005 6:50:04 AM

sql server replication:

thx Christian and Paul fro previous answers!

I have a SQL2000 server that hosts our accounting database and I want to
replicate it to another SQL2000 server so I can write reports etc, and do not
want to use the production server for these tasks. I tried to setup a
"snapshot" and was somewhat successful. My question is would it be better to
do a snapshot or transactional replication? The snapshot seemed to take along
time to run. I also do log backups every 15 minutes.

ps Paul I ordered your book...hope it will help also.
--
Rick Rushing
System Administrator
SQL Newbie

Re: Best technique for Replication

Rick Rushing
6/14/2005 8:00:11 AM

Paul,

There will be about 20 users on the SQL production server and only myself
using the other SQL server. My goal is to find a way to have a copy of the
database on the production server to the other server for use in writing
reports etc. So you think transaction would be a better approach?

ps you are right..it was Hilary's bok on replication.
--
Rick Rushing
System Administrator
D & J Construction

[quoted text, click to view]

Re: Best technique for Replication

Rick Rushing
6/14/2005 8:53:09 AM

Thanks Paul

I will pursue using transactional when my book arrives. We just installed
these SQL servers back in October so it will be a while before we upgrade.

thanks again for the input.
--
Rick Rushing
System Administrator
D & J Construction

[quoted text, click to view]

Re: Best technique for Replication

Paul Ibison
6/14/2005 3:37:14 PM

Rick,

snapshot is sometimes OK but it'll lock the tables and you can't really do
this regularly, and unless all your data is changing it is overkill.
Transactional would be more appropriate. Log shipping is sometimes used, but
you have to be out of the standby server when the log is restored, which in
most cases rules it out.

Rgds,

Paul Ibison, SQL Server MVP

BTW the only book I've written is my address book :) - Hilary's the man for
replication books and it's a very useful resource.

Re: Best technique for Replication

Paul Ibison
6/14/2005 4:29:26 PM

Rick - yes this is quite a common approach, and gives you the control to
decide exactly which tables are selected. BTW the Database snapshots in SQL
Server 2005 will offer an interesting alternative.
Rgds,
Paul Ibison

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.