change SQL Server 2000 Ent to Standard

How do I change a SQL Server 2000 Enterprise Edition
installation to a SQL Server 2000 Standard Edition
installation?Hi,
You need to remove sql enterprise edition and install sql standard edition.
You could do the below steps:-
1. Backup and databases (can be used if attach fails)
2. detach all the databases from sql enterrise edition
3. Remove sql enterprise edition and install sql standard with same
directory structure
4. Apply the same service pack level
5. Attach the MDF and LDF files back in standard edition.
If attach fails you could restore the database using the backup files
performed in step-1
Thanks
Hari
MCDBA
"Pooh" <anonymous@.discussions.microsoft.com> wrote in message
news:3e4101c47fa7$c89b1850$a301280a@.phx.gbl...
> How do I change a SQL Server 2000 Enterprise Edition
> installation to a SQL Server 2000 Standard Edition
> installation?|||Thanks Hari. I was hoping for some sort of "upgrade"
functionality, but if that is the only way....
>--Original Message--
>Hi,
>You need to remove sql enterprise edition and install sql
standard edition.
>You could do the below steps:-
>1. Backup and databases (can be used if attach fails)
>2. detach all the databases from sql enterrise edition
>3. Remove sql enterprise edition and install sql standard
with same
>directory structure
>4. Apply the same service pack level
>5. Attach the MDF and LDF files back in standard edition.
>If attach fails you could restore the database using the
backup files
>performed in step-1
>
>Thanks
>Hari
>MCDBA
>"Pooh" <anonymous@.discussions.microsoft.com> wrote in
message
>news:3e4101c47fa7$c89b1850$a301280a@.phx.gbl...
>> How do I change a SQL Server 2000 Enterprise Edition
>> installation to a SQL Server 2000 Standard Edition
>> installation?
>
>.
>|||Hi Pooh,
You should also look at this...
http://support.microsoft.com/default.aspx?scid=kb;en-
us;268361
Peter
>--Original Message--
>Thanks Hari. I was hoping for some sort of "upgrade"
>functionality, but if that is the only way....
>>--Original Message--
>>Hi,
>>You need to remove sql enterprise edition and install
sql
>standard edition.
>>You could do the below steps:-
>>1. Backup and databases (can be used if attach fails)
>>2. detach all the databases from sql enterrise edition
>>3. Remove sql enterprise edition and install sql
standard
>with same
>>directory structure
>>4. Apply the same service pack level
>>5. Attach the MDF and LDF files back in standard edition.
>>If attach fails you could restore the database using the
>backup files
>>performed in step-1
>>
>>Thanks
>>Hari
>>MCDBA
>>"Pooh" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:3e4101c47fa7$c89b1850$a301280a@.phx.gbl...
>> How do I change a SQL Server 2000 Enterprise Edition
>> installation to a SQL Server 2000 Standard Edition
>> installation?
>>
>>.
>.
>|||Hi Pooh,
You have to perform the manual steps (My previous post) to downgrade from
SQL Enterprise edition to SQL Standard Edition.
But the upgrade from Standard to Enterprise edition can be done directly
using the SQL server Enterprise edition CD.
Thanks
Hari
MCDBA
"Pooh" <anonymous@.discussions.microsoft.com> wrote in message
news:436a01c47fab$18ec6fe0$a401280a@.phx.gbl...
> Thanks Hari. I was hoping for some sort of "upgrade"
> functionality, but if that is the only way....
> >--Original Message--
> >Hi,
> >
> >You need to remove sql enterprise edition and install sql
> standard edition.
> >
> >You could do the below steps:-
> >
> >1. Backup and databases (can be used if attach fails)
> >2. detach all the databases from sql enterrise edition
> >3. Remove sql enterprise edition and install sql standard
> with same
> >directory structure
> >4. Apply the same service pack level
> >5. Attach the MDF and LDF files back in standard edition.
> >
> >If attach fails you could restore the database using the
> backup files
> >performed in step-1
> >
> >
> >Thanks
> >Hari
> >MCDBA
> >
> >"Pooh" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:3e4101c47fa7$c89b1850$a301280a@.phx.gbl...
> >> How do I change a SQL Server 2000 Enterprise Edition
> >> installation to a SQL Server 2000 Standard Edition
> >> installation?
> >
> >
> >.
> >