Home Forums Article Discussions Article Discussions by Author Discuss content posted by sathish siva Script to Get the Backup History RE: Script to Get the Backup History

  • March 3, 2014 at 6:51 am

    #1693539

    rjoseph (3/3/2014)

    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

    SQL 2000 does not have the compressed_backup_size. You wouldn't be able to use that part of the script for your SQL 2000 databases.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events