how to get backup and restore

Question

0.00/5 (No votes)

See more:

hi,

i have created school management application.
i have installed in client machine. it runs successfully.
how to take backup and restore database in client machine using c# application.
client machine has sql express installed.
database is in application path directory.

~~reply as soon as possible...~~

Posted 17-Jun-13 0:56am

Deebhanhari

Updated 17-Jun-13 1:01am

_Amy

v2

Add a Solution

Comments

_Amy 17-Jun-13 7:01am

It may be urgent for you, but not for us.

adriancs 25-Jun-13 13:04pm

http://lmgtfy.com/?q=how+to+backup+sql+database

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

_Amy · Answer 1 · 2013-06-17T00:59:00

Solution 1

Refer the links below:
Backup and Restore SQL Server databases programmatically with SMO[^]
Create Backups & Restoring Database In MSSQL [ASP.NET / C#][^]

--Amit

Posted 17-Jun-13 0:59am

_Amy

**AmitGajjar** · Answer 2 · 2013-06-17T01:02:00

Hi,

Even you have database file path you can not directly make a copy of that. you need to stop SQL server service to do that. If your database is online or your service is running then you may not able to perform restore operation. Although backup will be done.

But i suggest you to perform backup/restore only when your database is offline or your service is not running. If you have only single database on that machine then there will not be any problem with stopping sql service. In other case you need to make your database offline.

If you search in google, you can easily find the query to change state of your database to offline.

Hope this information will help you.

Thanks
-Amit

OriginalGriff · Answer 3 · 2013-06-17T01:02:00

Solution 3

See here:
Backing up an SQL Database in C#[^]

Posted 17-Jun-13 1:02am

OriginalGriff

Prasad_Kulkarni · Answer 4 · 2013-06-17T01:06:00

Solution 4

If you can;
Please refer:
How create Backup and Restore database in c# window application[^]

How to backup data from database in SqlExpress[^]
Autometically backup database from sql server[^]

Posted 17-Jun-13 1:06am

Prasad_Kulkarni

samadhan_kshirsagar · Answer 5 · 2013-06-20T03:16:00

Solution 5

hi this following links are useful to you.....
[^]
and

[^]
and
http://msdn.microsoft.com/en-us//library/ms187048.aspx[^]

Posted 20-Jun-13 3:16am

samadhan_kshirsagar

**Nirav Prabtani** · Answer 6 · 2013-06-25T04:47:00

Solution 6

try this...:)

http://www.dell.com/downloads/global/solutions/public/white_papers/sql2005_backup_wp.pdf[^]

Posted 25-Jun-13 4:47am

Nirav Prabtani

Updated 25-Jun-13 4:50am

v2