shipping. Is posible replicate by log shipping or transactional
replication schemes this DBs
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
|||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
<gnp1977@.gmail.com> wrote in message
news:1173280868.971366.142840@.c51g2000cwc.googlegr oups.com...
Im using MS SQL2000 and have and replication scheme with log
shipping. Is posible replicate by log shipping or transactional
replication schemes this DBs
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 DBs MASTER and MSDB can be replicated to the
stand by server, I need this because is a Continuity of Bussines site.
Thanks
|||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
<gnp1977@.gmail.com> wrote in message
news:1173296916.452161.294790@.n33g2000cwc.googlegr oups.com...
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 DBs MASTER and MSDB can be replicated to the
stand by server, I need this because is a Continuity of Bussines site.
Thanks
No comments:
Post a Comment