I have a database running on SQL Server 2008 R2. It has been running fine for over a year and a half. Unfortunately, the application vendor have just informed us that they only support the application on SQL 2005, and can no longer support us unless we migrate.
I have exported the entire database (data and schema) to a script with the target version set to 2005. The resulting file is just over 5GB. However, I'm unable to open the script on the target server, as I receive the following error:
error hresult e_fail has been returned from a call to a com component
I know this is not much to go on and is a generic error. Unfortunately there's nothing else in the logs. Is this something anyone has encountered before?