vaquas khan

vaquas khan

  • NA
  • 45
  • 0

How to move Database of SQL server 2000 to SQL server 2005

Jan 10 2010 7:51 AM
i have database name as United in sql server 2000 on system1, i take backup of this database and restored it on other system 2 in sql server 2005 , when i restored data then such type of error occurred ...

Restored Failed for server "My Server Name" ( Microsoft ,SQL Server.Smo)
Additional information:
system.Data.SqlClient.SQLError: RESTORE Detected an error on page (0:978) in DataBase "Name Of Database" as read from the backup Set(Microsoft.SQLServer.Smo)

please help me.....

give me the example also how i can do that.............................