I recently moved the database from an instance of SQL Server 2005 SP1 to "SQL Server 2008 SP1" (using detach-attach). Now I need to move it, but it is not with an error:
The database "MyDB" cannot be opened because it is version 655. This server supports version 612 and earlier. The down path is not supported.
After a little research, I believe that this is due to the new database parameter "Vardecimal Storage Format", which was somehow enabled for all my databases. I did not set this myself, but if I check the database parameters in Management Studio (2008), I see that all my databases are set to True. In addition, this option is disabled in the user interface, so I can not disable it.
Then I tried to disable the following:
exec sp_db_vardecimal_storage_format 'MyDB', 'OFF' go
which reported success, but when I check the parameters, it is still on.
Then I read this very detailed article: " http://msdn.microsoft.com/en-us/library/bb508963.aspx ", which states the following requirements to disable this option:
- Make sure the tables are not using vardecimal storage. Confirmed.
- Set recovery mode to simple and perform a full backup. I have done it.
But none of this matters. The option is still on, and I cannot change it.
Both instances of SQL Server are Express Edition (which should not support Vardecimal Storage Format anyway).
Any ideas on how to disable this option?
source
share