Post reply

Problem attaching 2000 db on 2005

  • August 30, 2006 at 8:36 am

    #113487

    Hi All,

    I did a search on attach and couldn't find any mention of this problem.  I have 3 databases running on MSDE on a remote computer.  I detached them and copied them to my computer via a portable hard drive.  I can attach them on my SQL 2000 server via Enterprise Manager with no problems.

    I cannot attach them via SQL Server Management Studio Express to a local SQL 2005 instance when logged in as 'sa' or as any user.  Through trial and error I found that if I login to SQL Server Management Studio Express using Windows Authentication, I can attach them but this will not help me because our accounting software needs to open them and do the conversion and it doesn't use WA mode.

    I hope this is making sense.

    When I try to attach it logged in as 'sa', the error I get is: "Database 'amwsys' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery. (Microsoft SQL Server, Error: 3415)"  I have checked the readonly status and it is not read-only plus that doesn't stop it from mounting the other way.  I checked all of teh links from the error messsage and there is no follow-up info.

    Thanks,

    Bill Mason

     

     

  • August 30, 2006 at 8:50 am

    #657547

    For me that doesn’t do any sense. I’ve do that operation for several times without any problem.

    Sorry to ask but did you check:

          If the data/log files are write protected.

          The database was on-line and running in the source server.

          The permissions of the accounts used for the process

     

     

    Feel free to contact me,

     

    PaL

     

    email:pal_soft@hotmail.com

    www: will be available soon

  • August 30, 2006 at 8:57 am

    #657552

    Hi Paul,

    Yes, I checked to make sure they are not write protected in the operating system and I checked the settings within the db by attaching them in Enterprise Manager and reviewing the properties.

    I made sure they were not attached to the SQL2000 system and I also tried stopping the SQL 2000 service while I was working.

    I am logging in as 'sa'

    Thanks,

    Bill

  • August 30, 2006 at 8:59 am

    #657553

    Hello Bill,

    You can do one thing. As you said that you could attach them to one of your local 2000 instance, try to make a full backup of the databases and then restore them on to the SQL 2005 instance.

    This might do the trick for you.

    Thanks

     


    Lucky

  • August 30, 2006 at 9:10 am

    #657563

    Hi Lucky,

    I did try that and I was able to restore the databases to SQL2005.  My problem is that these files belong to an accounting system and it needs to read them itself and then run an upgrade script that converts them to SQL2005 while it is modifying structures, stored procedures, etc.  If I replace the SQL2000 copies with SQL2005 copies of the files, the upgrade fails.

    Thanks for the help.

    Bill

  • October 18, 2007 at 12:09 am

    #742992

    The DBF file and LDF file need to have full control permissions for the NT account that the SQL server service is using. It worked for me.

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

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