I have Microsoft SQL Server 2008 and am uploading a .bak file of one of the databases to a website hosting account but they only currently support MS SQL Server 2005 .bak files - i've already paid acocunt fee's so obviously don't want to have to move somewhere else.
Is there anyway of making the sql server 2008 save the .bak file in the same format that a 2005 sql server would read?
Incase this helps - this was the error that they received while trying to put up the .bak 2008 database version:
"Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The backed-up database has on-disk structure version 661. The server supports version 539 and cannot restore or upgrade this database."
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.