.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Windows Application >> Post New QuestionBookmark and Share Subscribe to Forum

database backup through coding in windows application..

Posted By: gopal     Posted Date: April 28, 2009    Points:2   Category :Windows Application
hi..

i want to backup the sql server database through my application..

for example the database name "example" means through my application i want to back up that database..

how to do that..

its urgent..

nedd ur suggestions in c#

regards
gopal.s

Responses
Author: Praveen             
Posted Date: April 28, 2009     Points: 5   

Hi,
you can use ADO.Net to backup database try this code below is the sql statement


Backup DATABASE [databaseName] TO disk'c:\a.bak'


Author: Athira Sreejith             
Posted Date: April 29, 2009     Points: 5   

Hi..

For more Refer:

http://www.dotnetspider.com/forum/203291-Database-backup-through-coding-windows-application.aspx

Author: Akhil Raj       [Moderator]      
Posted Date: May 04, 2009     Points: 5   

hi friend you can use DMO object in .net for accessing sql server methods.

The following articles explains the concept in .net 2.0 in sql server 2005

http://www.codeproject.com/KB/database/SQL_Server_2005_Database.aspx


Author: elizas             
Posted Date: March 17, 2010     Points: 5   

Using the SQL SMO object we can easily take backup of SQL database through code.

http://www.mindfiresolutions.com/Backup-SQL-Database-Through-Code-In-VBNET-846.php



Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend