Click here to Skip to main content
15,878,814 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello friends

i have a project where i used a local database
the ConnectionString is this "Data Source=|DataDirectory|\Database.sdf"

i want to know how can a tack back of this file using c# code and also again restore the back up file in to the windows application .

please help me.

Thanks
Posted

With an SDF file, the easiest way is just to copy it - an SDF file is self contained, and just taking a copy using either File.Copy or the file system will be fine. Just make sure you aren't using it at the time! :laugh:
 
Share this answer
 
Click this below link its clearly show step by step with screen shot for Take Full Backup of a Database Using SQL Server Management Studio

http://www.mytechmantra.com/LearnSQLServer/How-to-Backup-Database-SQL-Server-P1.html[^]


This is good and quick one mostly no need for any other way its my personal advise!!!

[edit]unnecessary code block removed and clickable link[/edit]
 
Share this answer
 
v2

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900