I have finished my web application and now, it is going to deploy to a real server.  However, my another concern is BackUp the Database. 

I try to use third-party software to do Backup process, but everytime it runs the backup, it logs the error: "There has been a sharing violation".  How can I solve the problem to backup Database file during the web application running.

 Many thanks.

Jason

It would be a good idea to tell us which database product you are using, Sql Server, Oracle, etc. ...

I am using SQL Server.

Hi,

You can write T-SQL and execute this T-SQL in your ASP.NET project or in another application such as Windows Services to backup your Database.

You can execute this T-SQL using SqlConnection, ExecuteNonQuery on SqlCommand.

For example:

USE master
GO
EXEC sp_addumpdevice 'disk', 'AdvWorksData', 
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\BACKUP\AdvWorksData.bak';
GO
BACKUP DATABASE AdventureWorks 
 TO AdvWorksData
   WITH FORMAT;
GO

For more information, see http://msdn.microsoft.com/en-us/library/ms188409.aspx

I hope this helps.

Hi,

 I tried to write the following code, but it returns: "Could not locate entry in sysdatabases for database 'MyDB'. No entry found with that name.  Make sure that the name is entered correctly.  BACKUP DATABASE is terminating abnormally."  I am sure the connection is correct.  Any idea with this?  Thanks. 

        Dim myConnection As New SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("MyConnectionString").ToString)
        Dim myCommand As New SqlClient.SqlCommand
        myConnection.Open()

        myCommand.Connection = myConnection
        myCommand.CommandText = "BACKUP DATABASE [MyDB] TO DISK = N'D:\MyDB.BAK' WITH FORMAT"
        myCommand.ExecuteNonQuery()

        myConnection.Close()
        myConnection.Dispose()

Hi,

The error message indicates that the db name (MyDB) does not exist in sysdatabases. You check in SSMS by expanding the database node and see if it exist or execute the below query to see if the db is present there:

Select name from master.sysdatabases where name='MyDB'

I hope this helps.

Dear,

 I tried to run your code, but it shows: Invalid object name 'master.sysdatabases'.   I have no idea to solve my problem.  In fact, I am junior in SQL Server.  So, I try to post my information as details as possible, so that you can give me advice.

 I am using VWD Express 2005 to program a web application with a DB under SQLExpress.  My code for the connection between web application and DB as follows:

<add name="MyConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyDB.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

 In the Database Explorer of VWD, I only find my DB file: MyDB.mdf

Any idea about that?  Thanks.

Hi,

I am sorry. It should be "Select name from master..sysdatabases where name='MyDB'".

I hope this helps.

It does not prompt error message now and return the following message.. then, what should I do for running the backup code?

Running [dbo].[TryOnly].

name                                                                                                                            
--------------------------------------------------------------------------------------------------------------------------------
No rows affected.
(0 row(s) returned)
@RETURN_VALUE = 0
Finished running [dbo].[TryOnly].