Home Forums SQL Server 2008 SQL Server Newbies New DBA job, done some digging on Database and have some concerns! RE: New DBA job, done some digging on Database and have some concerns!

  • Yeah, exactly what Gail said. You should have a backup strategy for all your databases in production. How far back your backups should be based on your requirements for how far back you should keep data. Since constency checks have not been regularly run on your databases I asked because if you have database corruption you may have to go back to a database that is quite old and restore all the transaction log backups in order to fix the corruption and ensure no data loss.

    Joie Andrew
    "Since 1982"