问题描述
我正在进行数据库备份和还原.
我在按用户位置进行本地服务器备份和还原方面取得了成功，但是当我进行远程服务器数据库备份和还原时，我连接了远程sqlserver并获取了备份，然后将在远程系统而非本地系统上创建备份文件，然后将其还原到数据库中如果我从远程系统中删除该文件然后还原，则将从远程系统还原文件还原.给出异常.
I am working on Database backup and restore.
I have success on local server backup and restore as per user location but when I go for remote server database backup and restore I connect remote sqlserver and get backup then the backup file will be created on remote system not local system then I restore that database it will be restore from remote system back file if I remove that file from remote system then restore. Gives the exception.
Restore sqlRestore = new Restore();
BackupDeviceItem deviceItem = new BackupDeviceItem(dataFilePath + "\\" + databaseName + ".bak", DeviceType.File);
sqlRestore.Devices.Add(deviceItem);
sqlRestore.Database = databaseName;
ServerConnection connection = new ServerConnection(serverName);
connection.LoginSecure = false;
connection.Login = "gjgjg";
connection.Password = "ytryr";
Server sqlServer = new Server(connection);
sqlRestore.Action = RestoreActionType.Database;
String dataFileLocation = dataFilePath + "\\" + databaseName + ".mdf";
String logFileLocation = dataFilePath + "\\" + databaseName + "_log.ldf";
//System.Data.DataTable logicalRestoreFiles = sqlRestore.ReadFileList(sqlServer);
//sqlRestore.RelocateFiles.Add(new RelocateFile(logicalRestoreFiles.Rows[0][0].ToString(),dataFileLocation));
//sqlRestore.RelocateFiles.Add(new RelocateFile(logicalRestoreFiles.Rows[1][0].ToString(),logFileLocation));
sqlRestore.ReplaceDatabase = false;
//sqlRestore.Complete += new ServerMessageEventHandler(sqlRestore_Complete);
sqlRestore.PercentCompleteNotification = 10;
//sqlRestore.PercentComplete += new PercentCompleteEventHandler(sqlRestore_PercentComplete);
sqlRestore.SqlRestore(sqlServer);
我想将.bak文件存储在本地系统上并从本地还原到远程服务器
谢谢
I want to store .bak file on local system and restore from local to remote server
Thank You
推荐答案
这篇关于备份和还原远程sqlserver的smo claase的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！