Buk usu


Hi,

I would like to find out if there is any way to upgrade SQL Server 2000 (Ent) to 2005 (STD)

The Instance has many logins and jobs etc and I dont want to loose those

A document or some advice on how to go about it would help

Thanks




Re: Upgrading SQL Server 2000 Enterprise Edition to SQL Server 2005 Standard Edition

Deepak Rangarajan


You perform side by side upgrade but not inplace upgrade refer http://msdn2.microsoft.com/en-us/library/ms143393.aspx,

Either you can perform backup and restore or detach and attach the dbs
  • take a full backup of all your dbs before uninstalling ENT edition and script all the jobs and script logins using http://support.microsoft.com/kb/246133/
  • uninstall enterprise and install std edition as default/named instance
  • restore all the user dbs from the backup
  • you will not be able to restore system dbs and hence you need to run the scripts you took in step1 to recreate jobs and logins !
Refer http://www.microsoft.com/downloads/details.aspx FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en
as well !
- Deepak







Re: Upgrading SQL Server 2000 Enterprise Edition to SQL Server 2005 Standard Edition

Arnie Rowland

You cannot 'downgrade' Enterprise Edition to Standard Edition.

You must Uninstall Enterprise and then Install Standard.

Refer to this article for instructions about moving or attaching the system databases.

http://msdn2.microsoft.com/en-us/library/ms345408.aspx

Then re-Attach your existing databases.







Re: Upgrading SQL Server 2000 Enterprise Edition to SQL Server 2005 Standard Edition

Buk usu

does this mean I can attach msdb from a SQL2000 (ent) to SQL2005 (std) install

that would sure save me the task of scripting all the jobs

Thanks





Re: Upgrading SQL Server 2000 Enterprise Edition to SQL Server 2005 Standard Edition

Deepak Rangarajan


does this mean I can attach msdb from a SQL2000 (ent) to SQL2005 (std) install

No you cannot attach/restore the system dbs as it is different edition and version as well ! your only option is to script the jobs and logins ! you can only attach the user dbs and similarly restore the user dbs !

- Deepak





Re: Upgrading SQL Server 2000 Enterprise Edition to SQL Server 2005 Standard Edition

Arnie Rowland

This article will guide you in the process of moving Logins, Jobs, etc.

http://support.microsoft.com/ id=314546