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
>

Migration SSIS in msdb to other server

I depolyed several package in a server A msdb in some logical folders

E.g. msdb\Task1\package1

msdb\Task2\package2

msdb\Task3\package3

I would like to migrate the package to other server B and keep the logical folders tree.

I know I can reploy the packages in B and move them to the logical folders tree one by one, it is too slow.

Is there any fast method to migrate the package and keeping the tree?

Thanks.

Sure, move the tables directly. Should work.

You can use a package to move rows in the sysdtspackagefolders90 and sysdtspackages90 tables. Move the packagefolders rows first to retain RI.

Be careful that there aren't identically named folders or packages, it could get confusing. Also, do this too much and you'll get duplicate IDs etc. So, proceed with caution!!!

Kirk Haselden
Author "SQL Server Integration Services"