I have just installed SQLExpress version 9.0.1399.
I was using an earlier version of the server before and backed up a copy of my mdf files for safety's sake. However when I now try and attach the old databases I get an error that the database files from the old non-release version (590) is not compatible.
Probably my own fault - the information was probably clearly on display deep in a file somewhere in the documentation (cough). However I would kind of like to get at the data in these files.
Is there any way of getting hold of an earlier version of SQLExpress which will handle these files? Or can they be opened in any other way?
The full error message I am getting is:
Database 'myCMS' cannot be upgraded because its non-release version (590) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database. (Microsoft SQL Server, Error: 950)
I have searched around for more information and the advice seems to be that I should open the database in an older copy of SQLExpress, dump the data with BCP and recreate the database.
So now my question is, where can I find installation files for earlier versions of SQLExpress as I don't seem to have a copy of the original executable?
|||I am afraid these are no longer available, you might be able to get them by calling Customer Support Services but this will cost money
No comments:
Post a Comment