Re: Side-by-side upgrade - moving master, msdb and model
- From: Johnny Lundgren <JohnnyLundgren@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 2 Feb 2007 06:01:00 -0800
Rodney,
Could you be more specific or my questions should be asked in a different
newsgroup maybe ?
/Johnny
"Rodney R. Fournier [MVP]" wrote:
Not being a SQL MVP my guess would be to then allow the installation process.
to upgrade those in place.
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:B5CE8E09-C88A-442E-91AB-67AD2BB87270@xxxxxxxxxxxxxxxx
Hello Rodney,
Yes, that´s what I thought.
So what I have to do here is to configure everything manually then ?
What does the statement below mean then - found on page 105 in the
"SQL2005UpgradeTechRef.doc" ?
"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"
/Johnny
"Rodney R. Fournier [MVP]" wrote:
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
- Follow-Ups:
- Re: Side-by-side upgrade - moving master, msdb and model
- From: Rodney R. Fournier [MVP]
- Re: Side-by-side upgrade - moving master, msdb and model
- References:
- Re: Side-by-side upgrade - moving master, msdb and model
- From: Rodney R. Fournier [MVP]
- Re: Side-by-side upgrade - moving master, msdb and model
- From: Johnny Lundgren
- Re: Side-by-side upgrade - moving master, msdb and model
- From: Rodney R. Fournier [MVP]
- Re: Side-by-side upgrade - moving master, msdb and model
- Prev by Date: Re: client can't connect when instance on one particular node
- Next by Date: third node will not join cluster
- Previous by thread: Re: Side-by-side upgrade - moving master, msdb and model
- Next by thread: Re: Side-by-side upgrade - moving master, msdb and model
- Index(es):
Relevant Pages
|
