40 pts.
 Restore SQL Server 2008 database backup error specified cast is not valid
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).

Software/Hardware used:
ASKED: July 19, 2012  5:37 PM
UPDATED: July 20, 2012  8:26 PM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. TLMercer   40 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _