Post reply

sql server 2000 restore backup

  • December 28, 2006 at 9:05 am

    #193558

    I've got this probleme with mmy restore backup

     

    microsoft sql-dmo (odbc sqlstate: 42000)  exclusive acces could not be obtained because the database is in use. RESTORE BACKUP is terminating abnormally

    Could somebody can answer me... i'm trying to do something with that...

     

  • December 28, 2006 at 9:20 am

    #680284

    It means that there are more than 1 connection on the database.  You can set the database to single_user, run the backup then back to multi-users.

     

    Or you can manually try to find all connections other than yourself and manually kill then (single_user will do that for you).

  • December 28, 2006 at 9:23 am

    #680286

    i'm the only one who can connect to this database...

    this is the joke abot it and i don't know why it's doing this....

  • December 28, 2006 at 9:41 am

    #680300

    Then it means you are connected twice to the database.

     

    You can go to the detach database wizard, there's an option to kill all connections there.  You can use that to flush the problem connection(s).

  • December 28, 2006 at 9:52 am

    #680306

    i'll try it and give you some feed back on it!!

    thx

  • December 28, 2006 at 12:00 pm

    #680339

    i found my problem...

    thx for the tips you gave me!!!

  • December 28, 2006 at 1:54 pm

    #680370

    So what was the problem?

  • January 25, 2007 at 2:52 pm

    #685707

    I am facing the same problem. Can you please share the issue and the solution.

    Thanks

    Nee

  • January 29, 2007 at 3:00 am

    #686092

    Yess I have this trouble too. :S

    how did u solve ur problem ?

    can u share this pls

    thanks

    ilyada

Viewing 9 posts - 1 through 8 (of 8 total)

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