Results 1 to 4 of 4
  1. #1
    tagteam is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    486

    Cant restore database

    Some data went missing from one of my databases so I am trying to restore a backup to see if I can get it back.

    I am logged in as an admin and using SSMS and clicking restore database. Then I select Device and choose file and choose the .bak file I want to import. I change the Destination to the new name I want, check that the files are set to restore as that new name and then click OK.

    However, it keeps failing.

    Restore of database 'TestRestore' failed
    Exclusive access could not be obtained because the database is in use.

    Why cant I restore this file to a new databse?

  2. #2
    tagteam is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    486
    I was able to get this resolved by deselecting Tail log and selecting Close connections

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,449
    So just to ask, was the data stored in the main Access database as well, was the data linked in another Access db or was the data in something else like SQL?

    NM, see the SSMS now.

  4. #4
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,029

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Restore database failed in SSMS
    By neenajk in forum SQL Server
    Replies: 1
    Last Post: 10-05-2022, 12:53 AM
  2. DB restore
    By WAVP375 in forum Access
    Replies: 2
    Last Post: 08-06-2015, 04:50 AM
  3. Database Restore Button
    By wolf in forum Access
    Replies: 8
    Last Post: 03-05-2013, 06:52 AM
  4. Start a from with restore
    By snoopy in forum Programming
    Replies: 8
    Last Post: 09-06-2012, 11:01 AM
  5. Restore menus?
    By rich in forum Access
    Replies: 2
    Last Post: 08-09-2011, 10:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums