Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2010
    Posts
    3

    Unanswered: cannot restore database

    hi,
    i just installed sql server 2005 express that previously has sql server 2000. When i try to restore database (that was backed up from sql servr 2000) to sql server 2005 express, got error message "the operating system returned the error '32(The process cannot access the file because it is being used by another process.)..."

    Anybody can help?

    Thanks in advance

  2. #2
    Join Date
    Aug 2010
    Posts
    25
    you need to disconnect the users if anybody using ,go to single user mode then u can restore

  3. #3
    Join Date
    Oct 2010
    Posts
    1
    I can advise an easier way of data recovery sql server 2005, the analysis can be performed by another program. hope it helps

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You have SQL 2000 running now, and it has the database files open.

    When you use SQL 2005 Express to restore the files, they attempt to overwrite the files that are in use by SQL 2000, which causes Windows to return the error message that you got to SQL 2005, which in turn passes the message to you.

    You need to restore the files for the SQL 2005 Express databse to a different location than is being used by the files for the SQL 2000 database. If you'd like help with that, you need to tell us what tool are you using to do the restore.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •