Re: Side-by-side upgrade - moving master, msdb and model

System databases on SQL 2000 are very different from system databases on SQL
2005. You can't just move then, though I am sure Geoff or one of the other
SQL MVPs will have a great work around or something.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"Johnny Lundgren" <JohnnyLundgren@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:2472D1A7-D1A8-4779-A630-E088822CFBCD@xxxxxxxxxxxxxxxx
Hello,

I am soon performing a side-by-side upgrade on completely new hardware.

The old stand-alone server has a 32-bit SQL 2000 Standard Edition SP3a
installed.
I want to move all databases to a 64-bit SQL 2005 Standard (SP2 - when it
is
released) clustered installation on the new hardware.

My question:

I want to move not only the user databases but also MASTER, MSDB, MODEL
databases to avoid having to recreate and configure logins, maintenance
jobs
etc.

Is this really possible ?

On page 105 in the "SQL2005UpgradeTechRef.doc" the following statement is
found:

"In some cases, you may want to copy the system databases, including the
master database, from the source SQL Server 2000 instance to the SQL
Server
2005 instance before transferring user databases. See the topic "Moving
System Databases" in SQL Server 2005 Books Online to see how to do this"

When checking the Books Online, I get the impression that moving MASTER,
MODEL and MSDB only applies when moving between two SQL 2005
installations.
Not from SQL 2000 to SQL 2005.

Can anyone clear this out for me ?

Regards

Johnny Lundgren



.

Relevant Pages

  • Re: Cluster IP Address change
    ... I've heard the same story from...after not hearing this in 2 years of SQL ... After changing sql ip address resource & sql name resource came online but ... sql server resource was failing. ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: 4 Queries about DB clustering
    ... I support the Professional Association for SQL Server ... First you install MSCS (Clustering). ... >> on a single logical device physically connected to all host nodes. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Choosing correct high availability setup
    ... normal SQL startup, DB integrity check, roll back non-committed ... MVP - Windows Server - Clustering ... Basically there will be an Access database that arrives via FTP at ...
    (microsoft.public.sqlserver.clustering)
  • Re: How to install service pack 3a on a failover cluster
    ... MVP - Windows Server - Clustering ... We have two instances of sql running so I ... > the second node and rebooted the first node. ...
    (microsoft.public.sqlserver.clustering)
Loading