When I click on "Backup and Restore Events" on the drop down list under the "Report" button I see the backup/restore report page but none of the backups that have completed so far are being shows or listed. Does anybody know why ? Thanks in advance.
I am wondering if this may be a job history issue, do you know what your msdb job history settings are? Try having a look in the msdb tables dbo.backupset and dbo.restorehistory and see if there's anything in there.
Thomas - the backupset and restorehistory msdb tables are showing backup / restore data correctly - don't see any issues with these tables. Satya - how can I find what the service pack level is ?
SELECT CONVERT(char(20), SERVERPROPERTY('ProductLevel')) ServicePack, CONVERT(char(20), SERVERPROPERTY('ProductVersion')) BuildNumber
Thanks, here's the result of that query: ServicePack BuildNumber ------------------ ------------------- RTM 9.00.1399.06
I don't know if it'll fix your issue, but it would be a good idea to apply Service Pack 2. SQL Server 2005 RTM is actually out of support already.
SP2 has been applied - that fixed the report issue indeed. Thanks for your help gentlemen - this is one awsome forum indeed. Keep up the good work. Regards.