Post reply

Datafiles corrupted

  • August 22, 2007 at 12:37 pm

    #174401

    Hi,

    In my database one file is corrupted. How can i find out which file is corrupted

    can any body please give me some suggestion in this issue

    Regaurds

    siva

  • August 22, 2007 at 11:02 pm

    #728776

    Hi siva,

       siva just see in MSDB database (system database) -->tables -->system tables -->dbo.suspect_pages.

    Run a select query (select * from dbo.suspect_pages).it will display all the corrupted files.

    regards,

    mighty

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply