Re: MSDB and MASTER DB
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Thu, 8 Mar 2007 10:10:40 -0500
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@xxxxxxxxx> wrote in message
news:1173296916.452161.294790@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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
.
- References:
- MSDB and MASTER DB
- From: gnp1977
- Re: MSDB and MASTER DB
- From: Hilary Cotter
- Re: MSDB and MASTER DB
- From: gnp1977
- MSDB and MASTER DB
- Prev by Date: Re: Type of Replication?
- Next by Date: MSmerge_conflict_publication_article table
- Previous by thread: Re: MSDB and MASTER DB
- Next by thread: Re: Custom business logic handler question
- Index(es):
Relevant Pages
|
