i use this code for backup but some error are given

Question

0.00/5 (No votes)

See more:

C#

private void button1_Click(object sender, EventArgs e)
        {
            _BackupDatabase("master", "C:\backup");
            
        }
        public void _BackupDatabase(string databaseName, string filePath)
        {
            try
            {
                Server sqlServerInstance = new Server(
                new Microsoft.SqlServer.Management.Common.ServerConnection(
                new System.Data.SqlClient.SqlConnection(@"Data Source=GAURAV-31B52EEB\SQLEXPRESS;Initial Catalog=master;Integrated Security=True")));// your connection string I place mine for illustration.. DON'T HARDLY WRITE IT, pass it as argument or add it in application configuration 
                Backup backupMgr = new Backup();
                backupMgr.Devices.AddDevice(filePath, DeviceType.File);
                backupMgr.Database = databaseName;
                backupMgr.Action = BackupActionType.Database;
                backupMgr.SqlBackup(sqlServerInstance);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message + " " + ex.InnerException);
            }
        }

error
======================
{"Backup failed for Server 'GAURAV-31B52EEB\\SQLEXPRESS'. "}

Posted 1-Jan-12 23:52pm

gauravrank

Updated 2-Jan-12 0:01am

Richard MacCutchan

v2

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-01-01T23:58:00

Solution 1

Chances are it's a permissions problem.
Windows 7 restricts access to the root folder of any hard disk to Admin only: try writing your backup to a subfolder that has "any user" read and write permissions instead.

Posted 1-Jan-12 23:58pm

OriginalGriff

Sarvesh Kumar Gupta · Answer 2 · 2012-01-02T00:04:00

Hi use below sp
 

 
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[Sp_DatabaseBackup]
as
Begin
DECLARE @name VARCHAR(50) -- database name
DECLARE @path VARCHAR(256) -- path for backup files
DECLARE @fileName VARCHAR(256) -- file name for backup
DECLARE @fileDate VARCHAR(20) -- used for file name
SET @path = 'C:\Users\Publishing\Desktop\'
SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)
DECLARE db_cursor CURSOR FOR
SELECT name
FROM master.dbo.sysdatabases
WHERE name NOT IN ('master','model','msdb','tempdb')
OPEN db_cursor 
FETCH NEXT FROM db_cursor INTO @name 
WHILE @@FETCH_STATUS = 0 
BEGIN 
SET @fileName = @path + @name + '_' + @fileDate + '.BAK'
BACKUP DATABASE @name TO DISK = @fileName
 FETCH NEXT FROM db_cursor INTO @name 
END 
CLOSE db_cursor 
DEALLOCATE db_cursor 
End

**AmitGajjar** · Answer 3 · 2012-01-02T00:44:00

Solution 3

Hi,

try to use SQL Authentication to backup. modify your ConnectionString with one of the SQL server user.

hope that may help you,

thanks
-amit.

Posted 2-Jan-12 0:44am

AmitGajjar

Wendelius · Answer 4 · 2012-01-02T10:03:00

Solution 4

To get the real problem, examine the SQL Server error log for example using SSMS. You'll find the same error in errorlog, but you also find the cause for this error just after the message you posted. That message should explain why the backup failed.

Posted 2-Jan-12 10:03am

Wendelius