When I try to restore an Umbraco 4 SQL Server 2008 Express db backup to my hosting company's SQL Server (I'm pretty sure its SQL Server 2005) I get the following error in the plesk control panel:

"Error: dbbackup failed: Unable to restore database 'umbracoPTNL'
[Microsoft][ODBC SQL Server Driver][SQL Server]The query uses non-ANSI outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibility level for current database to 80, using the SET COMPATIBILITY_LEVEL option of ALTER DATABASE. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes."

I've researched and tried changing the compatibility level to both 80 (& 90) as the error message suggests but I still get the error. The restore is via Plesk control panel so I don't have many other options other than to click a button to upload the backup file to initiate the restore. I don't even know if this error is caused by the restore script on their server or by some query within the Umbraco db?

I've contacted the hosting company tech support and in the past they've managed to restore the backup for me and somehow fixed the error. I've tried to ask them what they did to get it to work but they've never responded. Now I've sent them another one to restore but they've changed their tune and are saying that they can't restore it because of this error. I've tried explaining that they've done this for me numerous times but that doesn't help.

Has anybody seen this error before or any clues as to how to fix it?

Thanks!