SQL Database is in use and cannot restore

<< SQL Server - Kill any live connections to the DB | Home

SQL Database is in use and cannot restore

USE master

ALTER DATABASE <mydatabase>

SET SINGLE_USER

--This rolls back all uncommitted transactions in the db.

WITH ROLLBACK IMMEDIATE

RESTORE DATABASE <mydatabase> FILE = N'mydatabase' FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\mydatabase.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10

Share This Post:
Short Url: http://wblo.gs/11br

Print | posted @ Friday, March 31, 2017 3:17 PM

Comments on this entry:

# re: SQL Database is in use and cannot restore

by laibaejaz at 4/6/2017 3:29 PM

sql is still in use it never get old essayleaki have use it best database it is.

# re: SQL Database is in use and cannot restore

by edwardcross at 4/19/2017 2:19 AM

Awesome article. I’m most definitely interest in this one. I am in reality happy with article quality and direction. This post is spot on in informative how some ideology applies to any script location. Thanks a lot for preservation huge stuff. I am extremely a good deal grateful used intended for this place. Thanks a lot for protection massive things. Visit here: http://www.speedycustomessaywriting.org/