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!

  • November 18, 2012 at 6:46 am

    #1560085

    Joie Andrew (11/18/2012)

    First and foremost before even considering any changes to the current schema if it were me I would work to identify the current environment a little more. Specifically the potential data corruption.

    I would get the results of that DBCC CHECKDB run as soon as you can. Run the following on your system/user databases and post the results if any errors are reported:

    DBCC CHECKDB (<dbName>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Also, on the mission critical database how far do full and trans log backups go?

    Thanks Joie, will try run this in the week. What performance impact will it have on a production DB? The DB is up 24/7 with users connected at all times.

    I will double check how far back the backups go, what is the ideal length of time?

    thanks