how to create SQL server Backup on button click Windows c#

Accepted answer

hi,

try below links

http://www.c-sharpcorner.com/blogs/take-sql-sever-database-backup-from-winform1

http://www.c-sharpcorner.com/UploadFile/rohatash/creating-sql-server-backup-file-with-C-Sharp/

https://www.codeproject.com/Tips/873677/SQL-Server-Database-Backup-and-Restore-in-Csharp

1. Download the file and change sql server name, database name and password as on your pc.

2. Make above changes in app.config file.

3. It's a live demo.

Red Line Show in this Lines

using Microsoft.SqlServer.Management.Smo;

using Microsoft.SqlServer.Management.Common;

How to Add Microsoft.SqlServer.Management.Smo, Microsoft.SqlServer.Management.Common files in vs 2012

don't Show in Add Reference

Hi Jyothi,

PLease refer the below link , It explained well..

https://www.mssqltips.com/sqlservertip/1849/backup-and-restore-sql-server-databases-programmatically-with-smo/