Database is in use

-

Stop Connections to the database without single user and without script...

System.Data.SqlClient.SqlError: Exclusive access could not be obtained because the database is in use

Error:

TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'ServerName'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Exclusive access could not be obtained because
the database is in use. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------





Solution:

1- Open SQL Management Studio.
2- Management.
3- Activity Monitor.
4- Stop any connection to the selected database.

Comments

  1. Mina BoshraSeptember 29, 2011 at 11:21 AM

    you can also stop the web application in the IIS web server until you restore the database then start it again

    ReplyDelete

Post a Comment

Popular posts from this blog

How to put java applet in aspx page‏‏

-
private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here if((Session["Well_Cd"]!=null)& (Session["UserName"]!=null)) { Response.WriteFile("TopMenu.aspx"); Response.Write("< br> < applet codebase = \".\" Archive = \"test.jar\" code= \"Pkg_Scrn.C_Daily_Progress.class\" name = \"Tmplt\" "+ "width= \"100%\" height = \"680\" hspace = \"0\" "+ "vspace = \"0\" align = \"middle\" "+ "viewastext>"+" Session["Well_Cd"].ToString()+"\">"+ "< PARAM NAME=\"Usr_Cd\" VALUE=\""+ Session["UserCode"].ToString()+"\">"+ "< /applet>"); } else Response.Redirect("default.aspx"); }
Read more

Introduction to Object Oriented Programming Concepts (OOPS) in C#.net

-
Image
Introduction to Object Oriented Programming Concepts (OOPS) in C#.net   OOPS Concepts Class:   It is a collection of objects. Object: It is a real time entity. An object can be considered a " thing " that can perform a set of related activities. The set of activities that the object performs defines the object's behavior. For example, the hand can grip something or a Student (object) can give the name or address. In pure OOP terms an object is an instance of a class The above template describe about object Student Class is composed of three things name, attributes, and operations public class student { } student objstudent= new student (); According to the above sample we can say that Student object, named objstudent, has created out of the student class. In real world you will often find many individual objects all of the same kind. As an example, there may be thousands of other bicycles in existence, all o
Read more