Forum Replies Created

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

  • RE: SQL Database corruption issue

    So, I successfully tested yesterday on a test instance using the following script (as there are over 250 transaction log files!)

    RESTORE DATABASE [EproPat] FROM DISK = 'D:\tmp\EproPat_backup_2017_08_08_000106_1477461.bak' WITH...

  • RE: SQL Database corruption issue

    I've had to go back a while to the full database backup at 08/08/17 00:48 which passes DBCC CheckDB with no consistency errors.

    So just to confirm the first...

  • RE: SQL Database corruption issue

    Many thanks for the replies,

    We do have good backups of the database and Full recovery mode on the DB so hourly transaction logs are generated, so is it...

  • RE: SQL Database corruption issue

    I have also just done a REPAIR_ALLOW_DATA_LOSS on the test instance of the DB and it came back with the attached results...but I can't tell if any actual user data...

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