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

SQL Database is in use and cannot restore

USE master
GO

ALTER DATABASE <mydatabase>
SET SINGLE_USER
--This rolls back all uncommitted transactions in the db.
WITH ROLLBACK IMMEDIATE
GO

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
GO

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

Comments on this entry:

Gravatar # 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.
Gravatar # 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/
Gravatar # re: SQL Database is in use and cannot restore
by Sonia at 4/19/2017 7:37 AM
This article is extremely valuable for all people. London Best Chauffeur Service, My learning is increment subsequent to perusing article
Gravatar # re: SQL Database is in use and cannot restore
by Sam at 4/20/2017 7:17 AM
Like your post. http://www.newintrends.com/
Gravatar # re: SQL Database is in use and cannot restore
by anvayaa at 4/25/2017 1:53 AM
Hi,
This article is extremely good.
Thanks a lot for sharing this article.
Gravatar # re: SQL Database is in use and cannot restore
by sudaksha at 4/25/2017 5:19 AM
It was very informative and I look forward to reading more of them from you!
Gravatar # re: SQL Database is in use and cannot restore
by vshoot at 4/25/2017 5:31 AM
Thanks for the great info, You provide us very useful information.
Gravatar # re: SQL Database is in use and cannot restore
by Research papers writing service at 6/15/2017 1:29 AM
I personally like your post, you have shared good article. Research papers writing service It will help me in great deal.
Gravatar # re: SQL Database is in use and cannot restore
by Electrical Engineering Assignmen at 6/21/2017 1:39 AM
This is really great work. Thank you for sharing such a good and useful information here in the blog for students.
Electrical Engineering Assignment Help
Gravatar # re: SQL Database is in use and cannot restore
by jazz at 7/6/2017 1:18 AM
nice.my world
Gravatar # https://www.accountingassignment.com/
by https://www.accountingassignment at 8/18/2017 11:39 PM
This is really great work. Thank you for sharing such a good and useful information here in the blog for students.
Post A Comment
Title:
Name:
Email:
Comment:
Verification: