开发者

restore sql database

开发者 https://www.devze.com 2023-01-17 22:14 出处:网络
I want to restore a database using asp.net web application in C#开发者_C百科.. Can anyone help me with this?You have to use the following namespaces

I want to restore a database using asp.net web application in C#开发者_C百科.. Can anyone help me with this?


You have to use the following namespaces

using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;

simple example

public bool RestoreDB(string dbName, string backupPath, string newLocation,string userName,sring Password)
        {            
            ServerConnection con = new ServerConnection(serverName);
            if(userName=="")
                con.LoginSecure = true;
            else{
                con.LoginSecure = false;
                con.Login = userName;
                con.Password = Password;         
            }
            Restore restoreObj = new Restore();         
            var srv = new Server(con);
            if (srv != null)
            {
                restoreObj.Action = RestoreActionType.Database;
                restoreObj.Database = dbName;
                BackupDeviceItem resDevice = new BackupDeviceItem(backupPath, DeviceType.File);
                restoreObj.PercentCompleteNotification = 10;
                restoreObj.ReplaceDatabase = false;                
                restoreObj.Devices.Add(resDevice);                 

                restoreObj.PercentComplete += (sender, evtargs) =>
                {
                   //on progress callback
                };

                restoreObj.Complete += (sender, evtargs) =>
                {
                   //on competion callback
                };

                restoreObj.SqlRestoreAsync(srv);

            }
            return true;
        }
0

精彩评论

暂无评论...
验证码 换一张
取 消