CSharp program to backup database

Thanks everyone the first reply itself was really helpful and i tried used that Thanks to the others as well for your time
Others are really advanced for me.
 -Guru-

Hi Guru!

Refer this thread for your post…

http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/7690214d-4cba-4757-9956-05f0ca408db5/

Thanks!

--------------------------------------------------------------------
If this reply helps your post…then check "This is correct answer"

Hi guruparan,

Try this, first import following .net classes


using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Management;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;


Backup Function:

 public void BackupDatabase(String databaseName, String userName, String password, String serverName, String destinationPath)
        {
            Backup sqlBackup = new Backup();
           
            sqlBackup.Action = BackupActionType.Database;
            sqlBackup.BackupSetDescription = "ArchiveDataBase:" + DateTime.Now.ToShortDateString();
            sqlBackup.BackupSetName = "Archive";

            sqlBackup.Database = databaseName;

            BackupDeviceItem deviceItem = new BackupDeviceItem(destinationPath, DeviceType.File);
            ServerConnection connection = new ServerConnection(serverName, userName, password);
            Server sqlServer = new Server(connection);
           
            Database db = sqlServer.Databases[databaseName];
           
            sqlBackup.Initialize = true;
            sqlBackup.Checksum = true;
            sqlBackup.ContinueAfterError = true;
           
            sqlBackup.Devices.Add(deviceItem);
            sqlBackup.Incremental = false;

            sqlBackup.ExpirationDate = DateTime.Now.AddDays(3);
            sqlBackup.LogTruncation = BackupTruncateLogType.Truncate;

            sqlBackup.FormatMedia = false;

            sqlBackup.SqlBackup(sqlServer);
        }