Home Forums SQL Server 2008 Data Corruption (SS2K8 / SS2K8 R2) Corruption from backup/restore but original db check db is fine RE: Corruption from backup/restore but original db check db is fine

  • August 6, 2014 at 5:22 am

    #1735572

    GilaMonster (8/6/2014)

    Markus (8/5/2014)

    I know that is a very minor checkdb routine that is run upon a db restore.

    There is not. CheckDB runs only when it is explicitly run by someone or some job. There is never an automatic checkDB ever.

    Are you sure about that Gail?

    Below is an extract from a SQL Server log at the time a database was recovered from a Restoring state. I can assure you that the CHECKDB shown was not run by anyone or a scheduled job.

    07/31/2014 22:04:40,Backup,Unknown,Restore is complete on database 'BrightTalk'. The database is now available.

    07/31/2014 22:04:40,spid54,Unknown,CHECKDB for database 'BrightTalk' finished without errors on 2012-06-25 01:00:04.770 (local time). This is an informational message only; no user action is required.

    07/31/2014 22:04:40,spid54,Unknown,Recovery is writing a checkpoint in database 'BrightTalk' (5). This is an informational message only. No user action is required.

    07/31/2014 22:04:40,spid54,Unknown,Starting up database 'BrightTalk'.

    Regards

    Lempster