We are upgrading SQL server2005 Express to SQL Server 2008 R2. We want to replace 2005 Express with 2008 R2 on existing system. We have lots of questions about how to perform the upgrade safely and pull in our existing databases. The existing
database files are in C:\Program Files\Microsoft SQL Server\MSSQL.1. Also, we'll want to use the existing instance name to avoid having to reconfigure all of the installed clients at our user's workstations.
Should we uninstall the 2005 Express version first? Will that keep the existing databases on the system?
Or can we install 2008 R2 while the databases are live under the 2005 Express, or should we shut down 2005 Express first?
Will 2008 R2 use the same data folder or create a new one? If it uses the same folder will it automatically recognize our existing databases? If it creates a new one, I suppose we can use the migration Wizard.
Thanks for any help....
View Complete Post