This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(304, 63%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Which lock does SQL Server place during database restore
![](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(230.39999999999998, 89%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Did these answers help you? If the answer is useful, please click Accept Answer to let others with similar questions quickly find answers. If you have any questions, please feel free to let me know.
Best regards,
Aniya
Does SQL server take schema modification lock during database restore?
![](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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
none really, the database is basically in single user mode, only the restore has access.
Open a query window. Noe the spid in the status bar. Start a restore of a database of some size (so that the restore complete directly).
In a second window run, while the restore is running:
SELECT * FROM sys.dm_tran_locks WHERE request_session_id = <spid in restore window>
This will display the locks taken for the RESTORE.
Does SQL server take schema modification lock during database restore?
So rather than answering your question, I told you how you could test this.
RESTORE does take a lock on the database while running the restore operation, I would assume that it is a Sch-M to lock. But to say with certainty, I would need to test. But so could you.
I dont have test environment to test. Thank you ad please let me know
You seem to have a computer. :--) You can download and install SQL Server to make a test and edify yourself: https://www.microsoft.com/en-us/sql-server/sql-server-downloads.