Hi - quick question.
I wanted to upgrade pre-release version of SQL Express to the latest version, and wanted to make sure that none of the database information would be lost. The thing that concerns me is that it states to uninstall previous versions of SQL Server 2005 Express before installing the latest version. I threw the database tables into a backup directory, and I think this should be fine, but I want to be sure. Let me know. Thanks!
SQL Server 2005 Express - Upgrading will Lose Data?
mikeb_aaron
Hi Matt,
Version 1399 is the released version of SQL Server. If you want to update to SP1, you can do so by downloading the SP1 update from http://msdn.microsoft.com/vstudio/express/sql/download. If you want to upgrade to SQL Express with Advanced Services, you'll want to be sure to follow the instructions on our blog at http://blogs.msdn.com/sqlexpress/archive/2006/04/20/UpgradeToAdvanced.aspx.
You won't lose your data, even if you uninstall SQL Express first. You will need to manually re-attach your databases once you've installed the SP1 version of Express; this is easily done using Management Studio Express (which comes in Express Advanced) or using a T-SQL command in SQLCmd. (See the BOL for instructions on attaching using T-SQL.)
Regards,
Mike Wachal
nfedin
Here is my version information for the server management studio:
Microsoft SQL Server Management Studio Express 9.00.1399.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790
From the SQL Server Config manager:
File Version: 9.00.1399.06
What do you think
Philippe Quesnel
How old is the pre-release version of Express you're using
Upgrading from pre-release database formats is only supported for some CTPs (this isn't Express-specific - the database format is the same for all SKUs of SQL Server and there have been many format changes during the development lifecycle of SQL Server 2005).
Thanks