Mirror of master, msdb, tempdb, or model databases.

Hi Guys,

Since,You cannot mirror the master, msdb, tempdb, or model databases.What will happen if i create new login,change existing security profile and new jobs,change of existing job on princicpal db. how these will be mirrored to other server and in case failover, how it will treat.

Thaks

Mirroring works at the database level only. dts/ssis packages, jobs etc are not mirrored. Database users are mirrored but not their corresponding SQL Server login.

You need to keep a copy of dts/ssis packages, jobs etc on the mirror server and whatever changes you make to them on the principal server, you will also have to make on the mirror server if you want to keep the servers exactly in sync.

hope this helps

Migratre from SQL 2000 to SQL 2005

Migrating from SQL Server 2000 t o SQL Server 2005, what do I need to do wit
h
the system Database (master, tempdb, model, and msdb)? what needs to be
migrate over and what not need to moved over?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200707/1Have you read this guide:
http://www.microsoft.com/downloads/...&displaylang=en
Adam Machanic
SQL Server MVP - http://sqlblog.com
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"ajsql via droptable.com" <u35479@.uwe> wrote in message
news:749f424e180d9@.uwe...
> Migrating from SQL Server 2000 t o SQL Server 2005, what do I need to do
> with
> the system Database (master, tempdb, model, and msdb)? what needs to be
> migrate over and what not need to moved over?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200707/1
>

Migratre from SQL 2000 to SQL 2005

Migrating from SQL Server 2000 t o SQL Server 2005, what do I need to do with
the system Database (master, tempdb, model, and msdb)? what needs to be
migrate over and what not need to moved over?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200707/1
Have you read this guide:
http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&displaylang=en

Adam Machanic
SQL Server MVP - http://sqlblog.com
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"ajsql via droptable.com" <u35479@.uwe> wrote in message
news:749f424e180d9@.uwe...
> Migrating from SQL Server 2000 t o SQL Server 2005, what do I need to do
> with
> the system Database (master, tempdb, model, and msdb)? what needs to be
> migrate over and what not need to moved over?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server/200707/1
>

Migratre from SQL 2000 to SQL 2005

Migrating from SQL Server 2000 t o SQL Server 2005, what do I need to do with
the system Database (master, tempdb, model, and msdb)? what needs to be
migrate over and what not need to moved over?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200707/1Have you read this guide:
http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&displaylang=en
Adam Machanic
SQL Server MVP - http://sqlblog.com
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"ajsql via SQLMonster.com" <u35479@.uwe> wrote in message
news:749f424e180d9@.uwe...
> Migrating from SQL Server 2000 t o SQL Server 2005, what do I need to do
> with
> the system Database (master, tempdb, model, and msdb)? what needs to be
> migrate over and what not need to moved over?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200707/1
>