How to create a SqlServer database backup with .Net?

Question

I want to make a database backup with this C# code:

connect = new SqlConnection(con);
connect.Open();

// Execute SQL
SqlCommand command = new SqlCommand
(
    @"backup database MY_database to disk='d:\SQLBackup\wcBackUp1.bak' with init, stats=10",
    connect
);

command.ExecuteNonQuery();
connect.Close();

When I run it, the following error message shows up:

Cannot open backup device 'd:\SQLBackup\wcBackUp1.bak'. Operating system error 3(The system cannot find the path specified.).

If I change the path to d:\wcBackUp1.bak it seems to be ok, is without error, but the file does not exist, it was not generated.

If I run in SQL the command I have the message that it was 100% processed, but I didn`t see the file.

Could someone help me please?

AbrahamJP · Accepted Answer · 2011-03-17 09:35:58Z

5

Make sure the location "d:\SQLBackup\" exist in your database server and not on your client machine.

answered Mar 17, 2011 at 9:35

AbrahamJP

3,4507 gold badges32 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sgmoore · Accepted Answer · 2011-03-17 09:34:52Z

3

Two things to check.

The Sql Service may not have access to the d:\sqlbackup folder. Old Sql installs used to default to install the service with full access to the machine, but newer instances tighten that up. You could try changing the path to the directory where the default backups are stored.

Secondly, if the sql server is not on the same machine that you are running this program, then you must remember that the D: will be the D: on the sql server and not your local machine

answered Mar 17, 2011 at 9:34

sgmoore

16.1k6 gold badges46 silver badges72 bronze badges

Comments

tomfanning · Accepted Answer · 2011-03-17 09:34:06Z

0

Fundamentally, the Windows account that the SQL Server service runs under must have write permissions on the specified folder.

You can check what account this is by looking in SQL Server Configuration Manager, under SQL Server Services (look at the Log On As column)

Check what permissions that account actually has on the target folder using Explorer -> right click folder -> properties -> security -> advanced -> effective permissions.

One way to check that this is the problem is to change your code to back up to your SQL instance's backup folder, where the permissions are likely to be correct. For example

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup

answered Mar 17, 2011 at 9:34

tomfanning

9,6604 gold badges53 silver badges79 bronze badges

Collectives™ on Stack Overflow

How to create a SqlServer database backup with .Net?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related