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.
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.
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.