SQL Management Studio missing Log Shipping Monitor, and Taskpad View

Are this features still somewhere and if yes how can i access them
which where in SQL2000 Enterprise Manager

thx in advance
Thomas



Answer this question

SQL Management Studio missing Log Shipping Monitor, and Taskpad View

  • nonsence

    Related to Taskpad, I attempted this with a sql2000 instance and was unable to use the report icon.  The report icon is grayed out.  Any idea why   Bad install or unsupport on sql 2000   Thanks.
  • Lucky:)

    There aren't any reports for SQL Server 2000 servers defined in Management Studio.



  • D.A.P.

    The task pad was replaced by the reports in the Summary page, one of which is a Transaction Log Shipping Status report.  To see the reports, select the server node in Object Explorer, then click on the Report button in the Summary Page.  There are several reports available if you click the dropdown arrow next to the Report button.

    To actually change log shipping settings, you'll need to use the database properties dialog for the database.

  • Mike 2^2

    Even with SQL 2005 Datbase, if your compatibility level is set to 80, the DISK Usage reports will not work, other reports like Top Transaction History, Index statistics, do not work either. You have to set compatibility level to 90.

    Which is really bad, because in 99% cases, if you are upgraded your database from an older version, you have to set your database to compatibility level to 80 or lower. Basically, we lose the Taskpad view in SQL 2005


  • SQL Management Studio missing Log Shipping Monitor, and Taskpad View