1

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?

  • Does this happen when running the script? Or opening the script in SSMS? – gbn Oct 4 '11 at 4:38
  • When opening the script. – Matt Oct 4 '11 at 4:42
  • See this: sqlnewsgroups.net/sqlserver/… – gbn Oct 4 '11 at 4:51
2

Please have a look at this link . Looks like you're running into address space limitation, and the suggested resolution is to use sqlcmd.

  • Many thanks. I did in fact use sqlcmd as a workaround (without knowing why it wasn't working) - unfortunately it has it's own limitations (I really needed to edit the script to change the file paths). – Matt Oct 4 '11 at 18:37
  • I run into this issue a while back. use Textpad, UltraEdit or JuJuEdit; they handle large files well. – DaniSQL Oct 10 '11 at 20:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.