Home Forums SQL Server 2008 Data Corruption (SS2K8 / SS2K8 R2) DBCC CheckDB successful but Backup teminates (Msg 3203, Level 16, State 1, Line 3 Read failed: 23) RE: DBCC CheckDB successful but Backup teminates (Msg 3203, Level 16, State 1, Line 3 Read failed: 23)

  • July 30, 2016 at 2:55 pm

    #1892776

    Thanks again Gail - what you've clarified is making more sense to me. Can I run by you my plan?

    - agree maintenance window

    - export all the data via an SSIS package

    - stop the SQL service

    - copy the current data files to another server

    - attach DB on new server, attempt the index rebuilds, file shrink

    - see if this allows backup to complete

    Unsy