SQL Server Performance

sql server 2005 management studio - reports

Discussion in 'SQL Server 2005 General DBA Questions' started by dba247, Aug 2, 2007.

  1. dba247 New Member

    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.
  2. thomas New Member

    Are you using 3rd party backup tools or using native SQL Server backups?
  3. dba247 New Member

  4. satya Moderator

    Whats the service pack level on client tools too?
  5. thomas New Member

    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.
  6. dba247 New Member

    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 ?
  7. MohammedU New Member

    SELECT CONVERT(char(20), SERVERPROPERTY('ProductLevel')) ServicePack,
    CONVERT(char(20), SERVERPROPERTY('ProductVersion')) BuildNumber
  8. dba247 New Member

    Thanks, here's the result of that query:
    ServicePack BuildNumber
    ------------------ -------------------
    RTM 9.00.1399.06
  9. thomas New Member

    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.
  10. dineshasanka Moderator

  11. dba247 New Member

    Thanks everybody - I will apply SP2 and let you know if that fixes the reports issue or not.
  12. satya Moderator

    It should as I can, if not you can try to reproduce the same from another client's machine.
  13. dba247 New Member

    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.

Share This Page