I=B4m using MS SQL2000 and have and replication scheme with log
shipping. Is posible replicate by log shipping or transactional
replication schemes this DB=B4s
Thanks

Hi, thanks for the answer, I need transfer the content of two DB to a
standby server...One of this have 35mb and the other have 13GB.
What method is the better??? Transactional or Log Shipping???
And other thing, de DB=B4s MASTER and MSDB can be replicated to the
stand by server, I need this because is a Continuity of Bussines site.
Thanks

Both system db's are in simple mode. Microsoft recommends backing the msdb
database up and shipping it. While it is possible to restore a master
database to another server, Microsoft recommends you transfer objects to the
standby server.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]
I´m using MS SQL2000 and have and replication scheme with log
shipping. Is posible replicate by log shipping or transactional
replication schemes this DB´s
Thanks

I'm not sure what the question is really here - the subject seems so
different to the body text :)
If you want to know the pros and cons of transactional replication vs log
shipping, please see this article:
http://www.replicationanswers.com/Standby.asp
If you are looking to set up a combination of log shipping and replication,
then please tell us a little more....
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

For these volumes I would use transactional replication if possible. For the
master and msdb databases, what sort of objects are you moving?

In master your linked servers and logins live. Do these change much? There
is a SQL DTS/SSIS job which will transfer the logins. Your msdb databsae
will contain DTS packages and jobs. These can be scripted/exported and sent
to the standby server.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]
Hi, thanks for the answer, I need transfer the content of two DB to a
standby server...One of this have 35mb and the other have 13GB.
What method is the better??? Transactional or Log Shipping???
And other thing, de DB´s MASTER and MSDB can be replicated to the
stand by server, I need this because is a Continuity of Bussines site.
Thanks