Script to Get the Backup History

Question

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)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

rjoseph Ten Centuries Points: 1087 More actions · Answer 1

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: 281334 More actions · Answer 2

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: 6488 More actions · Answer 3

Hello. I found misprint in this row:

WHEN 110 THEN 'SQL Server 2011'

SQL Server 2011 change on 2012