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

MIRROR and continuity

I have a question and excuse me if I look dumb ... but I can't MIRROR MASTER or other dBs. If I lose the server then (primary) ... will the db still be open? do I not require some of these non-mirrorable database to run?

You cannot mirror the system databases - master, model,msdb.

You can mirror all your user databases.

If you loss the server, you cannot access your databases.

Thanks.

Naras

|||I'm still confused. If I lose the physical server I know that I can't access the database. My question is that if MASTER goes down -- does everything on the server go down? If I'm mirroing TESTER -- and I lose MASTER, can I still leverage TESTER?|||

If MAster is screwed then so is your database server instance.

In that case you would failover to the other partner (the mirror of Tester, which would then become the Principal).

That must be located on another instance of SQL server and therefore must have it's own Master database. If you are using safe mode with a witness (which will allow automatic failover) the partner and witness would no longer be able to connect your initial Tester principal database and would failover automatically. The damaged original Master database is no longer involved in the scenario.

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
>