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

Question

how to create SQL server BackUp on button click in Windows Application c# with Sql Server 2008R2

Rafnas T P · 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

Jyoti Jodha · Answer

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

Ramesh Palanivel · Answer

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/