Down-grade

How easy is it to down-grade SQLServer 2000 from Enterprise edition to
Standard edition? Are there any risks involved? If yes, what are these
risks and what could I do to minimise them?See if this helps:
INF: Effects of Moving a Database from SQL 2000 Enterprise Edition to SQL
2000 Standard Edition
http://support.microsoft.com/default.aspx?scid=kb;en-us;268361&Product=sql
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Griff" <Howling@.The.Moon> wrote in message
news:OKBA8UhfEHA.3988@.tk2msftngp13.phx.gbl...
How easy is it to down-grade SQLServer 2000 from Enterprise edition to
Standard edition? Are there any risks involved? If yes, what are these
risks and what could I do to minimise them?|||Hi Vyas
If I have read this topic correctly, then this is for moving databases from
one SQLServer running Enterprise version to another SQLServer running
standard edition.
I'm more interested in physically down-grading an existing server.
Griff|||Hi Griff,
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
FYI, I have never done this type of downgrade.
Thanks
Hari
MCDBA
"Griff" <Howling@.The.Moon> wrote in message
news:uv6DZAifEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi Vyas
> If I have read this topic correctly, then this is for moving databases
from
> one SQLServer running Enterprise version to another SQLServer running
> standard edition.
> I'm more interested in physically down-grading an existing server.
> Griff
>|||Hari Prasad wrote:
> Hi Griff,
> 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
> FYI, I have never done this type of downgrade.
Although I've not downgraded systems like this, I've never had a problem
restoring databases on SQL 2000 Personal, even ones created in Enterprise
Edition.
John.