Best Practices msdb replication

[djj55]

Hello, With SQL server 2000 I would like our replication/fail over server to have a copy of the msdb and master databases. When created the instance on our replication server we did not use these two databases thus how can I make sure they are the same?

We are using Log Shipping to "copy" the main databases to the server.

Thanks
djj

 

[mrdenny]

Changes to jobs, and logins should be copied manually between the two servers. You can't log ship or replicate data in system databases.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[djj55]

Hello Denny,
Thank you for your reply. I had an incorrect word 'main' should have been 'working'.
When you say copy do you mean to manually do the same thing to the fail over server or can I just copy the two system databases? We are backing these two up on a nightly basis.

Thank you again,
djj

 

[mrdenny]

When I say copy I mean to manually do the same thing (to the jobs, logins, linked servers, etc) to the backup server as well as the production server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[djj55]

Thank you for the clarification. I will have to remember that in the future.

Thanks
djj