Upgrade to SQL Server 2005

29 Nov 2007 7:27 AM

Lukasz Glaz

I need to upgrade SQL Server 2000 to SQL Server 2005 on 10 development
workstations. How it should be done to aviod problems:
1. Upgrade SQL Server 2000 instance to SQL Server 2005.
2. Uninstall SQL Server 2000 and then install SQL Server 2005.
3. Reinstall the whole operating system on the development machines
and then install SQL Server 2005.

What is the best and fastest option?

Thanks in advance
Lukasz Glaz

29 Nov 2007 7:32 AM

Zarko Jovanovic

Lukasz Glaz wrote:

> I need to upgrade SQL Server 2000 to SQL Server 2005 on 10 development
> workstations. How it should be done to aviod problems:
> 1. Upgrade SQL Server 2000 instance to SQL Server 2005.
> 2. Uninstall SQL Server 2000 and then install SQL Server 2005.
> 3. Reinstall the whole operating system on the development machines
> and then install SQL Server 2005.
>
> What is the best and fastest option?
>
> Thanks in advance
> Lukasz Glaz

imho, the best is:

5. Install 2005 as a named instance (if named instance is not a
problem), move all databases from 2000 to 2005 (either backup/restore or
detach/attach), uninstall 2000 (JustInCase:just stop services, set
them to start:manual)

29 Nov 2007 7:47 AM

Uri Dimant

Lukasz
First of all run Upgrade Advisor tool (can be downloaded from MS site) to
see that you databases do not have any issues in regard SQL Server 2005
Second,make sure that you have lastest full backup of all databases.
If you are permitted for downtime , uninstall SQL Server2000, install SQL
Server 2005 and restore all databases .

Also see
http://dimantdatabasesolutions.blogspot.com/2007/03/detaching-and-attaching-database.html

Show quote

"Lukasz Glaz" <Lukasz.G***@gmail.com> wrote in message
news:e819b22c-27a4-4d0a-bf5e-c3c5bfea2d4e@g30g2000hsb.googlegroups.com...
>I need to upgrade SQL Server 2000 to SQL Server 2005 on 10 development
> workstations. How it should be done to aviod problems:
> 1. Upgrade SQL Server 2000 instance to SQL Server 2005.
> 2. Uninstall SQL Server 2000 and then install SQL Server 2005.
> 3. Reinstall the whole operating system on the development machines
> and then install SQL Server 2005.
>
> What is the best and fastest option?
>
> Thanks in advance
> Lukasz Glaz