BackUp Software Namespaces... which u will indclude...... using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using Microsoft.SqlServer.Management.Smo;using Microsoft.SqlServer.Management.Common; Coding which u will on the click event of connect button... private void btnConnect_Click(object sender, EventArgs e) { try { if (cmbsrv_name.SelectedItem != null && cmbsrv_name.SelectedItem.ToString() != "") { ServerConnection srvcon = new ServerConnection(cmbsrv_name.SelectedItem.ToString()); srvcon.LoginSecure = false; srvcon.Login = txtuserid.Text; srvcon.Password = txtPassword.Text; srv = new Server(srvcon); foreach (Database db in srv.Databases) { cmbDatabase.Items.Add(db.Name); } } else { MessageBox.Show("Please select a server first", "Server Not Selected", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } If u are running sql by windows auth.... then remove login and password and type Integrated security = true; type this code on the click event of backup button after conneted to the sql... and for full suppot please download this file...
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: