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

Convert text to Speech ASP.Net C# Audio Recognation

-
using SpeechLib; using System.Threading; private void button1_Click(object sender, EventArgs e)         {             if (textBox1.Text != "")             {                 SpVoice voice = new SpVoice();                 voice.Volume = 100;                 voice.Speak(textBox1.Text, SpeechVoiceSpeakFlags.SVSFlagsAsync);                 voice.WaitUntilDone(Timeout.Infinite);             }             else                 MessageBox.Show("Please enter text for speech","Text to Speech", Me...
Read more

ASP.NET 2.0 Tips and Tricks 1

-
Maintain the position of the scrollbar on postbacks: In ASP.NET 1.1 it was a pain to maintain the position of the scrollbar when doing a postback operation. This was especially true when you had a grid on the page and went to edit a specific row. Instead of staying on the desired row, the page would reload and you'd be placed back at the top and have to scroll down. In ASP.NET 2.0 you can simply add the MaintainScrollPostionOnPostBack attribute to the Page directive: MaintainScrollPositionOnPostback="true" AutoEventWireup="true" CodeFile="..." Inherits="..." % >
Read more