Home Forums SQL Server 2005 Administering Placing a Development Database on the same SQL Server instance as the Production database RE: Placing a Development Database on the same SQL Server instance as the Production database

  • I'm gonna pile on.

    This is a bad idea, there is so much that can go wrong that endangers your production environment that it simply isn't worth the risk.

    You could build another instance perhaps but that would be very dependent on the amount of memory and processors, at least in this case you could better control your risks.

    With all that said if they demand you do it I'd write up something specifying the dangers and make them sign off on it explicitly so later WHEN something happens they can't claim "we didn't know". Its not much but its something..

    CEWII