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 2008 Forums  SQL Server Administration (2008)  DOWNGRADE Enterprise to Standard -MASTER database?

Author  Topic  lge Starting Member 1 Post Posted - 2011-04-04 : 07:48:00 Hi! I want to perform the downgrade 'SQL Server 2008' version of 'ENTERPRISE' to 'STANDARD' on the same machine and I have a question about the MASTER database. Does anyone perform this operation? I found instructions on how to do it on the site. http://learnsqlwithbru.com/2009/09/24/downgrading-sql-server-enterprise-edition-to-standard-edition/ In a nutshell, the whole operation downgrade the above instructions are: 1. Detach the User Databases 2. Generate database script to create users 3. Physical files to backup system databases MASTER, MODEL, MSDB 4. Uninstall SQL Server 2008 Enterprise 5. Install SQL Server 2008 Standard 6. Attach the User Databases 7. Overwrite the physical databases files (only) MODEL and MSDB install 'STANDARD' files previously copied the installation database 'ENTERPRISE' 8. Run the script to create database users On a test server I made the whole operation downgrade, but at the step '7 'is also overwrite MASTER database and does not perform step '8'. -The first time when I log on to the user 'sa' I received an error message ("Server is an upgrade in script mode. Only an administrator can connect at this time" Error: 18401)) -So I logged on to the database as a systems administrator (window), and logged off. -During subsequent logons to any user, no longer displays any error and everything seems to work correctly together with users and linked servers. MY QUESTION Is the overwrite MASTER database (from the installation ENTERPRISE) to install STANDARD causes / may cause some errors / malfunction?