• I was concerned by the blanket statement that development databases should be restored nightly.  I understand where the author is coming from, but this idea only applies to development environments where the database never changes.

    There are ways to work around this like having the developers apply their schema changes every morning before they start working, but that is an added step that most developers would rebel against.

    Like all things I guess it depends on how many development databases you would have to maintain.  Since my team works with more than 300 development databases this isn't even practical.

    Just my 2 cents worth.


    Lee Ragans
    Database Administrator
    Turner Broadcasting System Inc.