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!

  • bugg (11/18/2012)


    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

    For an immediate run for your production system you may use the following DBCC command, it's less intensive than a full check and recommended for production systems. You will at some point though, need to run a full check and as already suggested you could do this on a restored copy of the database on an offline server.

    DBCC CHECKDB ('YourDB') WITH ALL_ERRORMSGS, PHYSICAL_ONLY

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉