Click here to Skip to main content
11,496,146 members (1,590 online)
The site is currently in read-only mode for maintenance. Posting of new items will be available again shortly.
See more: C# SQL
how to backup and Restore a Service based-Database mdf file in C#?
i do not access to Sql Server because i use only sql express basic on Ms Visual Studio Installer , so , do not linked me to backup and Restore on SqlServer.
Posted 8-Jun-13 6:44am
Edited 3-Jul-13 1:22am
v4
Comments
ThePhantomUpvoter at 8-Jun-13 12:00pm
   
Did you try anything? Anything at all? Even a simple search? http://www.codeproject.com/search.aspx?q=backup+database&x=0&y=0&sbo=kw
ThePhantomUpvoter at 2-Jul-13 10:06am
   
Maybe you should clarify why you do not want to use SQL Server functionality when you are using SQL Server?
The Web is full with answers. You have several approaches to choose from:
A) SMO:
SQL Server 2008 - Backup and Restore Databases using SMO[^]
B) SQLDMO:
http://www.csharphelp.com/2006/10/sql-server-backuprestore-through-sqldmo-and-c/[^]
C) ADO.NET Commands:
http://cavedweller92.wordpress.com/2012/12/13/create-backup-restoring-database-in-mssql-asp-net-c-2/[^]
I suggest you take the first approach.
  Permalink  
Easiest way i found on the web is below:

How to Backup and restore sql server database
http://www.webcodeexpert.com/2013/05/how-to-backup-and-restore-sql-server.html[^]
  Permalink  

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

  Print Answers RSS
0 Dnyaneshwar@Pune 692
1 RyanDev 230
2 CHill60 208
3 Sascha Lefèvre 195
4 Sergey Alexandrovich Kryukov 124
0 Sergey Alexandrovich Kryukov 10,401
1 OriginalGriff 8,910
2 Sascha Lefèvre 3,899
3 Maciej Los 3,422
4 Richard Deeming 2,600


Advertise | Privacy | Mobile
Web03 | 2.8.150520.1 | Last Updated 3 Jul 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100