Results 1 to 2 of 2
  1. #1
    neenajk is offline Novice
    Windows 11 Access 2016
    Join Date
    Oct 2022
    Posts
    3

    Restore database failed in SSMS

    I am trying to restore adventureworks database using this guide (using .bak)
    https://qawithexperts.com/article/sq...l-server-s/315

    But I get error, database is in use? until i restart
    Why I am getting this error.

  2. #2
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,029
    For restoring a database you need exclusive access to the database. In use could mean a front end application (like access) has an open dataset , or another user is logged in doing some stuff, or the job agent is running a job, ... . Restarting will kick all users from the system granting you exclusive access to the database.

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

Similar Threads

  1. SSMS wont recognize accdb file format
    By Tuckejam in forum SQL Server
    Replies: 2
    Last Post: 03-10-2021, 02:43 AM
  2. Replies: 3
    Last Post: 10-09-2019, 10:26 AM
  3. DB restore
    By WAVP375 in forum Access
    Replies: 2
    Last Post: 08-06-2015, 04:50 AM
  4. Database Restore Button
    By wolf in forum Access
    Replies: 8
    Last Post: 03-05-2013, 06:52 AM
  5. Replies: 1
    Last Post: 06-13-2012, 04:52 PM

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
  •  
Other Forums: Microsoft Office Forums