RESTORE failed to a different server

• wannabe dba

  SSCommitted

  Points: 1524

  More actions

  October 31, 2007 at 2:44 pm

  #119158

  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?

• Vidhya Sagar

  SSCrazy Eights

  Points: 8216

  More actions

  October 31, 2007 at 7:05 pm

  #747295

  Try restore using restore command.

  Restore

  Regards..Vidhya Sagar
  SQL-Articles

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  October 31, 2007 at 8:48 pm

  #747302

  Sounds like a naming issue. Can you restore the backup without creating a database first?

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  November 1, 2007 at 11:51 pm

  #747619

  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