Database Grouping in MS SQL - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Database Grouping in MS SQL

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-28 : 08:22:46

Alex writes "Is there a way to group databases in SQL using a single SQL Server? For example, can I do the following :


MySQL Server Group
----------------
|-Database Group A
      |- Database A1
      |- Dababase A2
      |- Database A3
      |- Database A4

|-Database Group B
      |- Database B1
      |- Dababase B2
      |- Database B3
      |- Database B4

Thanks in advance for any suggestions.
Alex"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-04-28 : 20:01:56

Nope

The only way you could do that is if you used SQL 2000 and set up mulitple instances.

So you could have

MyServer\GroupA running as a separate service to MyServer\GroupB

then add them both to your Enterprise Manager.

Damian

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources