Standard and Enterprise Editions

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Standard and Enterprise Editions

Author

Topic

Blin
Starting Member

36 Posts

Posted - 2005-03-24 : 10:14:34

We are currently running SQL Server Enterprise Edition on our development server and are planning on replacing it with Standard Edition of SQL Server. Are we going to be able to attach the databases after reinstalling Standard Edition? Are the databases going to be functioning ok? Any potential problems that we may be encountering?

Thanks for your help.

nr
SQLTeam MVY

12543 Posts

Posted - 2005-03-25 : 21:50:33

Databases should attach without problems - make sure you have reliable backups before detaching though.
Also make sure the new server has the same collation as the old.

see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-03-26 : 11:48:26

Along with having a good backup, it might be a good idea to run a DBCC CHECKDB before you do the detach/attach routine.

-ec

kish
Starting Member

45 Posts

Posted - 2005-03-29 : 07:49:53

Hold ON... I hope you dont have Log Shipping / Clustering installed on your EE. These features are not supported in SE.

--Kishore

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources