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