Hello Sathish,

When I parse this script, I got no errors but when tried to execute it to get the backup history on SQL 2000 or 2008 databases from MSSMS 2008, I got the following error messages below.

Msg 207, Level 16, State 3, Line 2

Invalid column name 'recovery_model'.

Msg 207, Level 16, State 3, Line 2

Invalid column name 'compressed_backup_size'.

Would you please help me in getting this to work.

Regards,

Reynold