February 26, 2014 at 12:05 pm
Comments posted to this topic are about the item Script to Get the Backup History
--
Thanks & Regards,
N.S.Sathish(SQL DBA)
March 3, 2014 at 6:46 am
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
March 3, 2014 at 6:51 am
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
March 14, 2014 at 6:20 am
Hello. I found misprint in this row:
WHEN 110 THEN 'SQL Server 2011'
SQL Server 2011 change on 2012
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy