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."
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes. We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple. The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.