Friday, March 23, 2012

Restore database from Yukon June CTP to September CTP

Hello:

I am trying to restore a database that was created with the June CTP version of Yukon to another box that has the September CTP installed. However, I am getting the following error:

-
"The database was backed up on a server running version 9.00.0852. That version is incompatible with this server, which is running version 9.00.1314. Either restore the database on a server that supports the backup or use a backup that is compatible with this server.

RESTORE DATABASE is terminating abnormally, (Microsoft SQL Server, Error: 3169)"
-

Shouldn't the September CTP be backward compatible with the June CTP? Would appreciate it if someone has any ideas on how to resolve this. I have verified the compatibility level to be 90 on the September CTP.

Thanks!

If you haven't uninstalled June yet, this might work. A kludge to be sure, and not for large databases.

Solution? Import the database to access. Save the create scripts to a file.

Then recreate the schema in Sept and use the Access Upsize Wizard to load the data.

Not ideal. However, it should work.

sql

No comments:

Post a Comment