Received a SQL Serer 2008 database backup newdatabase.bak from a site in UK and attempted to restore it onto my server in USA. Receive error . I assume this is a Server Collation difference issue. Can anyone help me overcome this so that I may be able to restore this backup on my SQL Server 2008 Enterprise edition? Thanks in advance. I am sorry I did not include the error on original question. The error returned is Specified cast is not valid. (SqlManagerUI).