Incremental Backup of Database

Kasthu Guna

Hay!

I need to write a C# based Incremental backup application. From that application only modified database files should be backup from our Database (SQL server Database ) .

Please any one suggest a way to do this. And it is good , if you suggest any tools also.

Thankyou

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Basit Khan10y ago
Dear,

Below is another code to take backup. Just Try this.

Dim sqlConnectionString As String = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DBNAME ;Data Source=.\SQLEXPRESS"
Dim conn As New SqlConnection(sqlConnectionString)
conn.Open()
Dim cmd As New SqlCommand
cmd.CommandType = CommandType.Text
cmd.CommandText = "BACKUP DATABASE DBNAME TO DISK='C:\location.BAK'"
cmd.Connection = conn
cmd.ExecuteNonQuery()
Kasthu Guna10y ago
Thank you so much ! Is any possibilities to use any existing API s to backup DB files. (Alpha VSS).
And some articles says , we can't make an incremental backup from SQL Server Db..Can you give me a clarification :)
Basit Khan10y ago
Use the Below code in .Net in Windows Apps. Create a exe file.

and use in Windows Task Sheduler to execute that exe file.

using Microsoft.VisualBasic;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
using System.Data.SqlClient;
public class Form1
{
SqlConnection con;
SqlConnection con1;
SqlCommand cmd;
SqlDataReader dread;
private void Form1_Load(object sender, System.EventArgs e)
{
connection();
blank("backup");
}
public void blank(string str)
{
string Lsm_Date = null;
Lsm_Date = Convert.ToDateTime(Today).ToString("dd-MMM-yyyy");
if (str == "backup") {
Timer1.Enabled = true;
ProgressBar1.Visible = true;
string s = null;
s = "D:\DataBackup\" + Lsm_Date + ".bak";
query("backup database to disk='" + s + "'");
}
}
private void Timer1_Tick(System.Object sender, System.EventArgs e)
{
if (ProgressBar1.Value == 100) {
Timer1.Enabled = false;
ProgressBar1.Visible = false;
System.Environment.Exit(0);
} else {
ProgressBar1.Value = ProgressBar1.Value + 5;
}
}
public void query(string que)
{
// ERROR: Not supported in C#: OnErrorStatement
cmd = new SqlCommand(que, con);
cmd.ExecuteNonQuery();
}
public void connection()
{
con = new SqlConnection("Data Source=.;Database=Master;integrated security=SSPI;");
con.Open();
cmd = new SqlCommand("select * from sysdatabases", con);
dread = cmd.ExecuteReader;
while (dread.Read) {
}
dread.Close();
}
public Form1()
{
Load += Form1_Load;
}
}