How to restore a DataBase from .bak file using (C#) SMO in DotNet 3.5?

The following code will help you to do this restore processing.


using Microsoft.SqlServer.Management.Smo;

string backupFile="Backupfile";//.bak file

string dbName = "DBName";

string dbServerMachineName = "MachineName";

Microsoft.SqlServer.Management.Smo.Server server = new Microsoft.SqlServer.Management.Smo.Server(dbServerMachineName);

Database database = new Database(server, dbName);

//If Need

database.Create();

database.Refresh();

//Restoring

Restore restore = new Restore();

restore.NoRecovery = false;

restore.Action = RestoreActionType.Database;

BackupDeviceItem bdi = default(BackupDeviceItem);

bdi = new BackupDeviceItem(backupFile, DeviceType.File);

restore.Devices.Add(bdi);

restore.Database = dbName;

restore.ReplaceDatabase = true;

restore.PercentCompleteNotification = 10;

restore.SqlRestore(server);

database.Refresh();

database.SetOnline();

server.Refresh();


...S.VinothkumaR.

7 comments:

  1. UnknownApril 3, 2009 at 12:15 AM

    sir i tried this code for restoring existing database,but it is giving problem during restore.

    the Error is :

    Restore failed for Server 'ROOM-4T0T2K9RH4\SQLEXPRESS'.

    please reply soon..

    ReplyDelete
  2. UnknownApril 15, 2011 at 5:24 AM

    I have tried this code for VS2005 and Sql Server 2005, but its giving error for Microsoft.SqlServer.Management.Smo.Backup namespace and when i copied Microsoft.SqlServer.SmoExtended.dll giving version error, is it like that this dll is for sql server 2008 and not run for 2005,
    please give me solution

    ReplyDelete
  3. UnknownMay 18, 2011 at 7:21 PM

    Thanks Vinoth, its working for me

    ReplyDelete
  4. bajinderAugust 21, 2011 at 11:17 PM

    using Microsoft.SqlServer.Management.Smo

    name space not found pls give me solution.

    ReplyDelete
  5. EMRE ÖNDEROctober 21, 2011 at 5:06 AM

    if you want add using Microsoft.SqlServer.Management.Smo

    come to solution explorer and right click to references select add references and select browse tab then select this path C:\programfiles\microsoftSqlServer\100\sdk\assemblies\ you can find in this folder what you want to include.. i perefer connection info , management sdk and two Smo files ;)

    ReplyDelete
  6. UnknownJune 15, 2012 at 12:18 AM

    Restore failed for Server 'ADMIN\SQLEXPRESS'.
    for this error is showing..

    ReplyDelete
  7. UnknownJanuary 18, 2013 at 10:51 PM

    How to create and restore database using SMO with version 4.0 and Sql server 2012, in 12 have Version 10/11 and for 3.5 have version 9.0, so this code is not working.

    ReplyDelete