Error restoring from SQL 2000 to 2005

Hi all,

I'm having problem to restore DB from SQL server 2000 to 2005.
Here is the error:

Restore failed for 'PROD'. (Micrsoft.SqlServer.Smo)
System.data.sqlclient.sqlerror:Invalid colun name'SC_BL_ADAPT'.(MicrsoftSQLSever.Smo).

Thanks for any help.

Regards,

Abrahim

__

check whether the backup is taken properly or not

RESTORE VERIFYONLY : To varify the database backup integrity

RESTORE FILELISTONLY : see the contents of backup file

Read more about these in BOL

Madhu

|||

Madhu,

The database has been backed-up with “Verify backup upon completion” on SQL server 2000.
I have no problem to restore the database in SQL 2000. It just SQL 2005 is not happy with column name “SC_BL_ADAPT”.

Any idea about “SC_BL_ADAPT”?

I’ll look it to RESTORE VERIFYONLY : To varify the database backup integrity

RESTORE FILELISTONLY : see the contents of backup file

Thanks in advance,

Abrahim

|||

sql server 2000 Restore Verifyonly is a useless command. it only check the header. But in SQL Server 2005 Restore varifyonly check the physical file integrity. check in 2005. And also try to restore this backup file in sql server 2000 as a temp database (only for the sake of error finding) and post back the result

Madhu

|||

Check the sql error log...if there is any other error related to restore.

|||

I think this is a tools problem and may not be the backup, try restoring using Query editior or have you tried?

Have you tested this from another machine?

|||Here is what I have done so far:
RESTORE verifyonly from disk =
N'C:\capdb_to_2005_1.bak'

Messages:
The backup set is valid.

/////////////////////////
then:
RESTORE FILELISTONLY from disk =
N'C:\capdb_to_2005_1.bak'

messages:
(4 row(s) affected)

Results:

capdb_Data C:\capdb_Data.MDF D PRIMARY 524288000 35184372080640
capdb_1_Data C:\capdb_1_Data D PRIMARY 1048576 35184372080640
capdb_Log C:\capdb_Log.LDF L NULL 1048576 35184372080640
capdb_1_Log C:\capdb_1_Log L NULL 13959168 35184372080640
/////////////////////////////////////////////

Yes, I try to restore it from several systems, but still have problem.|||You got the File List successfully, now have you actually tried a RESTORE DATABASE command?