151 questions
USE db_to_restore
Add that's already the cause, you self be connected to the database and so it is in use.
Use
USE master
to be connected to the system database, not to the user DB.
Issue to restore the schema
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 43%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Peter_1985
2,731
Reputation points
Dear all,
How to resolve it below?
Exclusive access could not be obtained because the database is in use.
I ran the following
USE db_to_restore
go
ALTER DATABASE db_to_restore SET SINGLE_USER WITH ROLLBACK IMMEDIATE
go
but it did not help.
SQL Server Database Engine
1 answer
Sort by: Most helpful
-
Olaf Helper 46,631 Reputation points2025-04-25T09:13:05.18+00:00 -
Peter_1985 2,731 Reputation points
2025-04-25T09:19:48.76+00:00 I've got the error like
A transport-level error has occurred when sending the request to the server.
when using "master" instead. I'm connecting to the DB within the server now.
-
Dan Guzman 9,376 Reputation points2025-04-25T14:58:40.9533333+00:00 Check the SQL Server error log for additional error messages related to the failed
ALTER DATABASEattempt and add the messages along with the actual script to your question. -
Peter_1985 2,731 Reputation points
2025-04-26T07:47:28.77+00:00 I retried that. I ran the following with success.
USE master
go
ALTER DATABASE my_sch SET SINGLE_USER WITH ROLLBACK IMMEDIATE
go
But I still got
Exclusive access could not be obtained because the database is in use. RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3101)
when restoring the schema from the backup file on the same SQL server 2012 express.
-
Dan Guzman 9,376 Reputation points
2025-04-26T15:45:27.08+00:00 Try removing the GO so that both the ALTER and RESTORE are submitted in the same batch.
-
Peter_1985 2,731 Reputation points
2025-04-28T04:25:26.5266667+00:00 Which line do you mean? I do the restore now by selecting this below.
-
Dan Guzman 9,376 Reputation points
2025-04-29T13:29:57.93+00:00 Script the
RESTOREcommand so that you can run all statements from the same session at the same time. This will help ensure another session doesn't connect to the database before the RESTORE. e.g.:USE masterALTER DATABASE my_sch SET SINGLE_USER WITH ROLLBACK IMMEDIATERESTORE DATABASE my_sch FROM ...GO -
Peter_1985 2,731 Reputation points
2025-04-30T01:51:56.9466667+00:00 I run this
USE master ALTER DATABASE my_sch SET SINGLE_USER WITH ROLLBACK IMMEDIATE RESTORE DATABASE my_sch FROM "C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.EXPR2012\MSSQL\Backup\my_sch.bak" WITH REPLACE GO
and have got
Msg 5064, Level 16, State 1, Line 3 Changes to the state or options of database 'my_sch' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it. Msg 5069, Level 16, State 1, Line 3 ALTER DATABASE statement failed. Msg 3206, Level 16, State 1, Line 4 Backup device 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.EXPR2012\MSSQL\Backup\my_sch.bak' does not exist. To view existing backup devices, use the sys.backup_devices catalog view. To create a new backup device use either sp_addumpdevice or SQL Server Management Studio. Msg 3013, Level 16, State 1, Line 4 RESTORE DATABASE is terminating abnormally.
The. .bak file was existing within the path above. What to adjust?
-
Olaf Helper 46,631 Reputation points
2025-04-30T05:11:22.5+00:00 Backup device 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.EXPR2012\MSSQL\Backup\my_sch.bak' does not exist.
As the message says.
You really have nowadays a x86 = 32 bit SQL Server installation?
-
Peter_1985 2,731 Reputation points
2025-04-30T06:10:35.9833333+00:00 Yes, you're correct.
-
Peter_1985 2,731 Reputation points
2025-05-02T03:36:24.4066667+00:00 Thanks. No other issues on this.
-
Peter_1985 2,731 Reputation points
2025-05-02T04:40:15.5333333+00:00 Thanks. No other issues on this.
Sign in to comment -