Restore Sqlserver Database Using C# Showing Error

Question

I am trying to backup and restore sql server 2008r2 database, and i successfully backup my database , But the problem is when i am trying to restore my DB its showing the following error Restore failed for Server 'XXXX-PC\SQLEXPRESS'

And Another important thing is that , When i Close the DB Connection (From server Explorer [right-click->Close Connection]) its working Normally And Correctly

Below is my Backup And Restore Code Please help me to fix the problem

public static void BackupDatabase(string backUpFile)
{
    ServerConnection con = new ServerConnection(@"XXXX-PC\SQLEXPRESS");
    Server server = new Server(con);
    Backup source = new Backup();
    source.Action = BackupActionType.Database;
    source.Database = "testBD";
    BackupDeviceItem destination = new BackupDeviceItem(backUpFile, DeviceType.File);
    source.Devices.Add(destination);
    //source.Devices.AddDevice(@"G:\MyBackUp.bak", DeviceType.File);
    source.SqlBackup(server);
    con.Disconnect();
}

public static void RestoreDatabase(string backUpFile)
{
    ServerConnection con = new ServerConnection(@"XXXX-PC\SQLEXPRESS");
    Server server = new Server(con);
    Restore destination = new Restore();
    destination.Action = RestoreActionType.Database;
    destination.Database = "testBD";
    BackupDeviceItem source = new BackupDeviceItem(backUpFile, DeviceType.File);

    destination.Devices.Add(source);

    destination.ReplaceDatabase = true;

    con.Disconnect();
    server.ConnectionContext.Disconnect();

    destination.SqlRestore(server);
}

This is the error : enter image description here

This is the error message in detail:

enter image description here

Look at the inner exception. Please post ex.ToString().

usr
– usr

2014-01-04 13:59:58 +00:00
Commented Jan 4, 2014 at 13:59 — usr
– usr, Commented Jan 4, 2014 at 13:59

Ben Thul · Accepted Answer · 2014-01-04 19:23:03Z

2

My guess is that your restore process can't get exclusive access to the database. The Server SMO object has a KillAllProcesses method that takes a database as an argument and does what it says on the tin.

answered Jan 4, 2014 at 19:23

Ben Thul

32.9k4 gold badges52 silver badges74 bronze badges

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

1 Comment

Arun CM Over a year ago

Thanks man.. Its works !!! , i added server.KillAllProcesses("DBName") to my code

Collectives™ on Stack Overflow

Restore Sqlserver Database Using C# Showing Error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related