Showing posts with label backed. Show all posts
Showing posts with label backed. Show all posts

Friday, March 9, 2012

Reattaching old database

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

Re-attaching database

I have upgraded my OS and reinstall a new fresh instance of SQL Server.
Before I backed up my database and saved it on a CD Rom, but now I can't re-attach it to the server. I receive an error message saying the my data file is not an SQL server database server file.

I am afraid of loosing all my data, view and procedures. I really need some help here...

Thanksdid u actually 'back up' or did you copy the data folder onto your CD.|||I back up the database first and copied the back up file on the CD, I did not copy the files from the data folder.