Re: MSSQL2K and MSSQL side by side in clustered environment

Yes, you can do this. You need to create a new group which has disks which
have not been used for any other SQL Server Virtual. Then install a new SQL
Server 2005 Virtual. (It will need a new name and new IP address.) Once
installed, you can finish the migration by using either attach/detach or
backup/restore. You can also minimize the amount of time the migration
takes by implementing either log shipping or replication from SQL Server
2000 to 2005 and then cutting over where they are synchronized.

--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com


"Björn Pettersson" <BjrnPettersson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:CF3CA7C9-DEE9-41DF-9C0C-FBF48B93156E@xxxxxxxxxxxxxxxx
>I haven't been able to find any publications on Internet regarding my
>concern.
>
> We have a MS SQL2K installation in a clustered environment, and would like
> to migrate to MS SQL2K5 using a side-by-side installation. To my
> knowledge,
> this should be possible. Could you please direct me to any documents
> describing how to perform this task. Is it as easy as creating two new
> resource groups (we're using two instances for the MS SQL2K installation
> today), create the necessary resources (sql name, sql ip, services and
> disks), and installing MS SQL2K5 to a different location than the current
> installation? The operative system on the servers are Windows 2003
> Enterprise
> Edition and the MS SQL 2K5 Server edition we intend to use is the
> Enterprise
> edition.


.

Relevant Pages

  • RE: Server cant be seen from the network
    ... Microsoft CSS Online Newsgroup Support ... I discovered that if I turned the SQL server ... NAT issues caused with the installation of the "full" SQL ...
    (microsoft.public.windows.server.sbs)
  • Help Please with a step by step keystroke by keystroke(or Mouse) illustration on how to setup a stan
    ... the most typical for the average developer wanting to push .Net SQL driven ... did it would involve a domain server, ... client network utility force protocol encryption is NOT checked) ... Please give a complete account of the standalone CA installation as this ...
    (microsoft.public.sqlserver.security)
  • RE: Server cant be seen from the network
    ... I did allow the accounting tech to ... After the "full" SQL server was loaded, ... NAT issues caused with the installation of the "full" SQL server/services, ...
    (microsoft.public.windows.server.sbs)
  • Re: installing help for sql 2005
    ... Now i installed the sql server2005 on one of my ... server and its running fine but i am now getting an other problem which is ... installation help with snap shots because i installed the sql server 2005 ... remote connections are disabled by default. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 Beta running on Windows XP Professional set up iss
    ... >loading a beta version of SQL Sever 2005 onto Windows XP Pro SP2. ... >complimentary copy as part of a 3 CD set including Visual Studio/SQL Server ... >> The setup process appears to get 90% through the installation but always ... >> that it may not be suitable to support the beta edition of SQL Sever 2005. ...
    (microsoft.public.sqlserver.setup)
Quantcast