Create Database backup in Solution folder on button click event mvc/asp.net

Question

1.00/5 (4 votes)

See more:

, +

I want to create my whole database backup just on single button click and inside solution folder.After button click .bak file will be downloaded.

Note:-

I need C# code to backup database on button click event and inside solution folder or in any folder whatever i need as per requirement

Thank U.

Posted 30-Jul-15 4:51am

itsathere

Updated 30-Apr-19 2:33am

v2

Add a Solution

Comments

virusstorm 30-Jul-15 13:21pm

Are you trying to backup the database from within your solution, no applications running or by launching an application in the solution and click the button to backup the database?

3 solutions

Solution 1

One simple way is, using a SqlCommand, you execute a BACKUP[^] command.

After the backup is successfully created, copy the files created where you want.

Just make sure that
- you have sufficient privileges.
- the target folder is accessible by the credentials your program uses.

Posted 30-Jul-15 4:56am

Wendelius

Updated 30-Jul-15 4:58am

v2

Comments

itsathere 30-Jul-15 11:02am

whatever u have written i think, it's sql command to backup database.

Wendelius 30-Jul-15 11:07am

I'm sorry but I don't quite understand your reply. SqlCommand is the class in SqlClient namespace to execute commands in a SQL Server database.

Solution 3

SQL server can only
backup to a drive that is accessible to the server - if you issue a command to backup a database to a folder on the C: drive, it will try to back it up to the C: drive on the database server, NOT to the C: drive on the machine on which the application is running (unless you happen to be running the application on the database server.

Posted 18-Sep-15 3:41am

Chris Quinn

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)

User 4180254 · Accepted Answer · 2015-07-30T05:04:00

Solution 2

Below links will give you some idea about your question.

http://stackoverflow.com/questions/9835553/how-to-backup-sql-database-programmatically-in-c-sharp[^]

https://social.msdn.microsoft.com/forums/sqlserver/en-US/7690214d-4cba-4757-9956-05f0ca408db5/database-backup-programmatically[^]

Posted 30-Jul-15 5:04am

User 4180254

Comments

itsathere 30-Jul-15 11:25am

Thanks.