Post reply

Error:Server: Msg 3101 restore error

  • July 6, 2005 at 12:13 pm

    #109802

    Hello all,

    I tried to restore database by using UNC name

     

    restore database Test3

    from disk = '\\servername\sharename\test3.bak'

    with recovery

    and i got this error.

    i am using domain account and i have full rights of share folder.plese help me

    Server: Msg 3101, Level 16, State 2, Line 1

    Exclusive access could not be obtained because the database is in use.

    Server: Msg 3013, Level 16, State 1, Line 1

    RESTORE DATABASE is terminating abnormally.

     

    Thanks

  • July 6, 2005 at 1:52 pm

    #571484

    The problem is there are users in the database at the time of the restore. The user could even be you. Make sure you're not in the database at the time (if you're running from Query Analyzer, make sure the database drop down is on master). Also, you can set the database for single user or restricted user mode using the ALTER DATABASE command if you are having trouble keeping folks out.

    K. Brian Kelley
    @kbriankelley

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

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