Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 530
  • Last Modified:

Create Folder in SQL Enterprise Manager for organizing databases

I was wondering if there is a way I can create folder/folders (storage container) within SQL enterprise manager for organizational purposes.

Example, I have a SQL 2008 Enterprise server cluster environment, with approximately 20 databases on it. I want to place the sharepoint databases in one container, websense DB's in another, VCenter in another, ect.

Any help would be much appreciated!

Thanks!!
0
jgreen1280
Asked:
jgreen1280
  • 3
  • 2
  • 2
  • +1
1 Solution
 
knightEknightCommented:
Right-click on SQL Server Group / New SQL Server Group.

Is this what you mean?
0
 
knightEknightCommented:
oh! sorry, I mis-read - I thought you said SQL 2000.  I need new glasses!
0
 
jgreen1280Author Commented:
No problem :-)

I cant seem to find where to create a folder for organizing databases, as referenced in this article (about half way down the page, under headding called "Folders"):
http://www.georeference.org/doc/creating_an_enterprise_server.htm

I understand this article must be for an older version of sql, but MSFT must have created a simple way for organizing large numbers of databases on a sql ent server
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
BrandonGalderisiCommented:
You cannot create folders for organizing databases on a server, only server groups for organizing servers.
0
 
jgreen1280Author Commented:
Thanks Brandon. So, in large environments, the only way to organize in enterprise manager is to deploy more sql servers?

I think microsoft has focused on the complex stuff so much, that they have forgotten the simple things, like organization and management. They boast about their sql product and how you can place many servers in a cluster, and use 1 or 2 cluster environments for all your sql needs, but wait, I have 80 databases in my corp env,  40 on each cluster -- but all the databases show up in a row - what a management nightmare.
Sorry for the venting, just sometimes wonder why companies as big as MSFT forget the most basic features; features that just make sense and not dificult to implement.

Thanks for your input!! I do apreciate it!
0
 
BrandonGalderisiCommented:
I've managed servers with 100-120 servers per instance and 50-60 instances.  I just accept it for what it is though.
0
 
jgreen1280Author Commented:
Thanks again!
0
 
Divya BhatiaAccountantCommented:
You can use the following software for this purpose - www.skilledsoftware.com
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now