Script to Get the Backup History

• sathieshsql

  Mr or Mrs. 500

  Points: 531

  More actions

  February 26, 2014 at 12:05 pm

  #304785

  Comments posted to this topic are about the item Script to Get the Backup History

  --

  Thanks & Regards,
  N.S.Sathish(SQL DBA)

• rjoseph

  Ten Centuries

  Points: 1087

  More actions

  March 3, 2014 at 6:46 am

  #1693538

  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

• SQLRNNR

  SSC Guru

  Points: 281344

  More actions

  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

• Konstantin Taranov

  SSCertifiable

  Points: 6498

  More actions

  March 14, 2014 at 6:20 am

  #1697109

  Hello. I found misprint in this row:

  WHEN 110 THEN 'SQL Server 2011'

  SQL Server 2011 change on 2012