home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,820 of 19,505   
   Erland Sommarskog to Cathy   
   Re: List all databases on all servers   
   15 Feb 13 10:38:31   
   
   From: esquel@sommarskog.se   
      
   Cathy (Cathy@Nospam.com) writes:   
   > Had a quick look at apexsql demo, looks nice but still requires me to   
   > enter all server names.   
      
   Yes. I will have to admit that I don't know any tips of discovering   
   SQL Servers.   
      
   > Ideally I need to track any new installations and ensure they comply to   
   > the most basic set of standards. (i.e backups & logfiles)   
      
   Then again, if I as a developer install SQL Server on my workstation   
   to have as my playground, should you really care? I can assure that I'm   
   running any backups! :-)   
      
   One tool to monitor servers is the Policy Based Management that ships with   
   SQL 2008 or later. I'm not entirely excited about all features, but I   
   think it works better for monitoring than preventing.   
      
   Again, you probably need to tell it which servers to monitor, but as I   
   said, I donä't think you want to monitor all instances in your network.   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca