Error while attaching a database

  • Have you tried attaching the database through EM?



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • Can you create a new db, detach it, and then attach it back right away? Almost seems like something's wrong with your install. Are the mdf/ldf from the same version of sqL?

  • Hi,

    Creating a new DB, detaching & attaching is working fine. Both, MDF & LDF files are from SQL2K. Still having a problem with the previous error message. Remember, this is caused of improper server shut-down.

    Kindly suggest on this.

  • I've been facinated by your question ( I've never met this problem but like to know the answer anyway) so I start diging;

    http://support.microsoft.com/kb/837938

    It also indicates a corrupted clustered index using the standard edition while adding new columns on a table.

    Hope this helps you out.

    GKramer

    THe Netherlands

     

  • Hi

    Tried to do the same but still having the same problem. I request to SQL DBAs to guide me.

     

Viewing 5 posts - 1 through 6 (of 6 total)

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