>>>>Hi,
>>>>
>>>>I am converting many of my customers to SQL Server. And I have to keep a copy of their database in my SQL Server. So the list is growing. I was wondering, is it possible to have groups of databases? That is, if I could have the following tree:
>>>>Databases
>>>> +Custom A Databases
>>>> Database1
>>>> Database2
>>>> +Customer B Database
>>>> Database1
>>>>and so on.
>>>>
>>>>Is this possible?
>>>
>>>No, you can't.
>>>But you can always install another instance of SQL Server with the customers name and put their DB there.
>>
>>Thank you, Borislav. For now I will leave things as they are. But when the list becomes too long I will look into creating another instance of SQL Server.
>
>
>BTW I wouldn't keep real Customers Databases attached to SQL Server (esp. if they have sensitive data).
>I'll backup them with password and will keep them in separate folders NOT attached to SQL Server.
>When I need some of them I'll restore it.
My customers databases do not have sensitive data. But I see your point. In time, when the dust settles, I will probably detach them and keep them in a backup folder. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham