Nevermind ....

sp_dbcmptlevel @dbname = ????, @new_cmptlevel = 80

ok, setting primary key on each table seems to have fixed it.

Well I tried doing another backup today and I got no errors using the same SQL. Restored fine too. I don't know what changed to make it trouble free this...

NULL 2E3812D0-CF25-4DCE-879C-4832DA3A34D7 2 1 B106E6C4-0000-0000-0000-000000000000 1 0 NULL Microsoft SQL Server 4608 2006-02-16 01:32:49.000 1

Forgot to mention I'm deleting out the .bak file via FTP between tasks.

Hmm.. even if i try backing up with T-SQL:

BACKUP

DATABASE [ehci] TO DISK =

Ok Steve, I'll run another backup and try again. Thanks.

Thanks Vladan

I've fixed up the dates in both dbs and in each table that the error occurred. I have put some test orders and customer registrations through and the date...

Ok, this is all the data I can get out of this db:

Query: --> SELECT dateCreated,dateCreatedInt, CONVERT(varchar(20), dateCreated,113) FROM Customer WHERE idcust > 145 ORDER BY dateCreatedInt

Vladan, here's my db data:

Query: --> SELECT dateCreated,dateCreatedInt FROM Customer WHERE idcust > 145 ORDER BY dateCreatedInt

Thanks for the reply David,

No I logged in to SMSS myself and backed it up to one of my web FTP folders. There was no existing db in the target...

Thanks for your help guys my Host was able to tweak some un-named setting and I was suddenly able to access the dbs.

Thanks Vladan, the field type is DateTime so my date is actually getting written as

11/02/2006 7:37:32 AM (Before upgrade)

2/11/2006 7:37:32 AM. (after upgrade)

I have other date fields which are varchar(25) which...

Thanks Ken, I'll refer it back to my host.

Thanks for your reply. I'm not sure what you mean by instance name. The error I reported was when I tried to connect to my host's SQL 2005 server via...