DB Attach Problem

  • I am having SQL SERVER with SP4 installed on the same.Everyday I am doing sync split of the server.After that I am attaching the database to server.

      Today after sync split,we cant able to attach the database.

    It is throwing error:-

      I/O error 1392 file or directory is corrupted and  unreadable.

      What can I do???? Also How to overcome this problem in Future???

     

      Thanking You,

      Salil

  • do another sync and split

    our job we have 27 steps involving 5 different servers. the entire thing is run off 2 servers.

    first we kill connections on the destination, detach, do the split and sync, attach and then run the EMC SRDF stuff. If any step fails it automatically goes to email the failure and stops the rest of the job except for the srdf part

    then when i get up at 6am, i check it and if it fails i mount any databases that need mounting even if it's old data. i would also make sure you don't have anything else running that may try to use the data at the same time. no maintenance jobs or anything.

    we run our backups from the BCV volumes during the day

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

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