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
SQL Server Setup & Upgrade
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
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.
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
does this mean I can attach msdb from a SQL2000 (ent) to SQL2005 (std) install
This article will guide you in the process of moving Logins, Jobs, etc.
http://support.microsoft.com/ id=314546