Home Forums SQL Server 2005 Administering Career growth - Production Support SQL Server DBA RE: Career growth - Production Support SQL Server DBA

  • Indianrock (9/3/2012)


    As far as Systems Admins taking over sql server support duties, I think that can work as far as infrastructure and backups ( where backups are handled by something other than native sql tools ).

    We've gone down that road twice, due to decisions being made by IT managers in the absence of any DBAs or DBA managers. The first time native sql backups and log shipping were replaced by Commvault backups administered by Systems Admins. This time we're headed towards Netapp snap backup and its not clear yet if the DBAs we now have will be involved in that or not.

    Our System Admins have so far steadfastly refused to get involved in the nuts and bolts of sql server which means they could not manage maintenance like reindexing and update statistics in any reasonable way.

    Have they ever tried doing a restore to make sure it all works as advertised? Any DR drills to make sure DR is actually working?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)