I need to change my current SQL 2000 enterprise editon to SQL 2000 standard
edtion. May I know what is the best way to do it?andrew,
You need to uninstall enterprise and install standard. There's no short
cut I'm afraid. You can upgrade from standard to enterprise though.
Steps:
1) Back up all your dbs
2) Detach all your databases
3) Uninstall enterprise
4) Install standard
5) Attach the databases
If the attach fails, you can restore them.
Read this before doing anything:
INF: Effects of Moving a Database from SQL 2000 Enterprise Edition to
SQL 2000 Standard Edition
http://support.microsoft.com/?id=268361
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
andrew wrote:
> I need to change my current SQL 2000 enterprise editon to SQL 2000 standar
d
> edtion. May I know what is the best way to do it?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment