Post reply

cms

  • March 17, 2009 at 2:01 pm

    #207138

    I have questions about central management server

    According to Books Online Versions of SQL Server that are earlier than SQL Server 2008 cannot be designated as a Central Management Server. But

    1) Can I manage sql 2000 or sql 2005 servers from CMS ?

    2) I have DEV and QA Databases both have one instance

    So for QA –Default = QA and QA\SQL2005 where QA =sql 2000

    For DEV –Default = DEV and DEV\SQL2005 where DEV =sql 2000

    Can I manage them from cms?

    How..??

  • March 17, 2009 at 11:51 pm

    #961597

    dallas13 (3/17/2009)

    I have questions about central management server

    According to Books Online Versions of SQL Server that are earlier than SQL Server 2008 cannot be designated as a Central Management Server. But

    1) Can I manage sql 2000 or sql 2005 servers from CMS ?

    2) I have DEV and QA Databases both have one instance

    So for QA –Default = QA and QA\SQL2005 where QA =sql 2000

    For DEV –Default = DEV and DEV\SQL2005 where DEV =sql 2000

    Can I manage them from cms?

    How..??

    Yes... you can even get to 7.0 servers from custom code. There a recent webcast by Microsoft on CMS and its tips and tricks. You should check it out at http://www.microsoft.com/webcasts/

    Thanks.

    Mohit.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

  • March 18, 2009 at 12:59 pm

    #962193

    Thanks Mohit,

    But can u please give me a direct link for that cms webcast?

    I m not able to find anything there

    and one more thing so do i need to make some custome codes to work with this?

  • March 18, 2009 at 4:03 pm

    #962319

    http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032402180&EventCategory=5&culture=en-US&CountryCode=US

    Thanks.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

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

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