attach database fails

  • Hi

    I detached one of my databases and copied the mdf file to another server. Shortly after I tried to attach the same database on the original server again. But now sql claims that the name "blabla_Data.MDF" may be incorect?? I also get a problem when I try to attach the database on the new server. Here I get the following error: "Error 5123_ CREATE FILE encountered system error 32(error not found) while attempting to open or create the physical file'D:\MSSQL\Data\blabla_Data.MDF'

    I detached several other databases, made a copy and then attached them again. All others successfully attached, both on the original server and the new one.

    Why, what???

    I do not understand this one.

    Please help

     

    Regards

    Dan

  • may be the particular DB is corrupted.Try DBCC commands and verify DB consistancy and try the same.

    RMK

     

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

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