Looking for the best practice to upgrade a soon to expire MSSQL 2005
evaluation server to a standard production server I understand
the license requirements. I have good backups of the
databases.
Should i just pop in a MVL mssql2005 cd and perform an in place
upgrade Or completely remove the eval version and install clean
Will i have to redo any SQL users i have added on this server
Thanks for any help. If anyone has a link to a KBB article i
would be happy to read that on my own as well, i just havent been able
to locate one.
MSSQL 2005 Eval upgrade to production?
Hot Topic
- SQL Server 2005 Express & Windows Reporting services
- Images in a table cell, conditional on a data item value
- How to install sql server 2005 developer edition over sql server express.
- remote connection problem with sql server express
- Connecting to SQL 2005 from a client pc
- Exporting Report Builder Tabular Report to CSV
- Sql server Express 2005 Advanced
- Insufficient System Resources
- Calling GetVirtualInput within SetUsageType method causes error 0xC0047041 on return
- cannot install sql server 2005 developer over sql server 2000 desktop edition
SQL Server
- How to calculate percentages on a dimension?
- Need help to make query
- Smo Column Object
- Different Data Types in Data Source View
- Integrating KPI in Reporting Services and drill down reports
- Installation for Windows XP PRo
- IIF driving crazy
- Help on replication from SQL 2005 to DB2/AS400
- Size of datafiles in a MSSQL2000
- SQL Server 2005 won't install
MSSQL 2005 Eval upgrade to production?
James Su
Nick Efremov
In place upgrade will work for you but once eval edition expires you will have to do uninstall and install.
In case of in place upgrade all logins are preserved but uninstall install would remove all logons and setting in system databases.