October 31, 2007 at 2:44 pm
I was trying to restore a fullbackup from a legacy server running on SQL Server 2000 to a different server running on 2005.I created the empty database and tried to restore the fullbackup after copying it over to the network to the new server.The restore reached 100% and gave me the following error" System.Data.sqlclient.sqlError:Invalid column name 'Wepay Theypay'.(Microsoft.sqlserver.smo).
Please could any of u guys help me resolve this issue?
October 31, 2007 at 7:05 pm
October 31, 2007 at 8:48 pm
Sounds like a naming issue. Can you restore the backup without creating a database first?
November 1, 2007 at 11:51 pm
In the database in SQL 2000 check if there is a column which has a 'space' in it. the error looks there is such a column and is failing out there.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply