Home > Archive > MS SQL Server > March 2006 > RE: Organizing file groups for multiple databases









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author RE: Organizing file groups for multiple databases
bantar

2006-03-26, 8:23 pm

Thanks for the reply, John. I understand that the configuration is not a
recommended one... as you can imagine I inherited the role of admin, and the
system and resources available are what they are for the near term. My
question is how to best organize what I have now, most importantly to improve
recoverability of the production dbs.


"John Bell" wrote:
[color=darkred]
> Hi
>
> Mixing production, test and development databases on the same server is not
> a great idea as problems with test or development may effect production. Even
> if you moved the databases onto different drives they will still be competing
> for shared resources.
>
> John
>
> "bantar" wrote:
>
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com