sqlserver backup using c# getting issue

Question

I want to create backup of particular database using C# code, and for that I am using following code.

Code

       Console.WriteLine("Backup manager");

        Backup bkpDBFull = new Backup();

        bkpDBFull.Action = BackupActionType.Database;

        bkpDBFull.Database = "SampleDB";

        bkpDBFull.Devices.AddDevice(@"D:\Temp\Back\fulBak.bak", DeviceType.File);
        bkpDBFull.BackupSetName = "Database backup";
        bkpDBFull.BackupSetDescription = "Code backup";
        bkpDBFull.Initialize = false;

        bkpDBFull.PercentComplete += CompletionStatusInPercent;
        bkpDBFull.Complete += Backup_Completed;

        Server MyServer = new Server("Data Source=.;Initial Catalog=SampleDB;User ID=user;Password=pass");

        bkpDBFull.SqlBackup(MyServer);

and the two event's are following.

CompletionStatusInPercent

    private static void CompletionStatusInPercent(object sender, PercentCompleteEventArgs args)
    {
        Console.Clear();
        Console.WriteLine("Percent completed: {0}%.", args.Percent);
    }

Backup_Completed

    private static void Backup_Completed(object sender, ServerMessageEventArgs args)
    {
        Console.WriteLine("Hurray...Backup completed.");
        Console.WriteLine(args.Error.Message);
    }

In the entire code it getting a only one problem in below code

Problem code

        Server MyServer = new Server("Data Source=.;Initial Catalog=SampleDB;User ID=user;Password=pass");

I think I had put name of sqlserver in wrong way.

I need a solution of how can I fix this issue.

Tony Hopkinson · Accepted Answer · 2013-03-04 09:46:07Z

2

You've mixed up the constructors. The argument for new Server, is either the name of the server (string), or an instance of the Microsoft.SqlServer.Management.Common.ServerConnection class in the smo name space. It's constructor takes a connectionstring as an argument.

answered Mar 4, 2013 at 9:46

Tony Hopkinson

20.4k3 gold badges35 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sagar Upadhyay · Accepted Answer · 2013-03-04 09:59:36Z

0

As here, Tony Hopkinson I had made more research and come up with a solution...

I just simple remove my Problematic code with following code...

        SqlConnection con = new SqlConnection(@"Integrated Security=SSPI; Data Source=.");
        ServerConnection sc = new ServerConnection(con);
        Server MyServer = new Server(sc);

So, I hope this will be useful to many other...

answered Mar 4, 2013 at 9:59

Sagar Upadhyay

8192 gold badges12 silver badges31 bronze badges

Collectives™ on Stack Overflow

sqlserver backup using c# getting issue

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related