Backup sqlserver database using code

Question

0.00/5 (No votes)

See more:

I want to backup sqlserver database using c# code.
For that i am using "BACKUP DATABASE" query.

So, suppose my "SQL server" is installed on same pc and i am trying to
running this query then this query is working perfectly.

But

suppose "SQL server" is installed on network environment means some on another system

I want to take "SQL server" database to my local system drive.

for example,

sql sever is installed on "TEST_SERVER"
and
another pc (say admin-pc) which is connected to same network
trying to take sqlserver database to local drive of "admin-pc"

what i am facing issue is that when i am trying to run code from local pc,
it is unable to access local system drive.

Getting error like this

Error

Means

it is able to connect sql server database.

it is able to take backup on system on which sql server is installed.

is is not able to take backup on local system drive

What I have tried:

BACKUP DATABASE test TO DISK = D:\1.bak

Posted 23-Mar-22 4:16am

Devendra Sarang

Updated 23-Mar-22 5:30am

v3

Add a Solution

2 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)

M Imran Ansari · Answer 1 · 2022-03-23T05:04:00

Solution 1

On remote location, create a share folder on your network environment and use the following query:

SQL

BACKUP DATABASE DatabaseName   
   TO DISK = 'YourSharedPath\DatabaseName.bak'

Your shared path could be like \\TEST_SERVER\SQLBackup\:

Posted 23-Mar-22 5:04am

M Imran Ansari

Updated 23-Mar-22 5:05am

v3

Dave Kreskowiak · Answer 2 · 2022-03-23T05:30:00

You would have to create a folder on your admin machine and share it, giving the account that's running your SQL Server services access to the share and appropriate permissions.

But, you would normally never do this as your machine would have to be on the network and running in order for the backup job to work. It would be better if the back was written to a place that is up and running all the time and then you just copy that backup to your own machine when you need it. Keep in mind, you're going to have to make sure the data is kept secure per company policy.