服务器的恢复失败

服务器的恢复失败

本文介绍了恢复数据库“服务器的恢复失败”xxx'“的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个问题。我试着像belov的代码。但我得到例外。并且例外是:

I have a problem. I tried the code like belov. But i am getting exception. and the exception is :

"Restore failed for Server 'SMART0090\SQL2008RR2'."  FailedOperationException. .... the error is at "restore.SqlRestore(server);" line

你对这个问题有什么看法?代码是:

What do you think about the problem? The code is :

public void RestoreToDatabase(string NewDatabaseName, string BackUpFile, string ServerName, string UserName, string Password)
    {
        ServerConnection connection = new ServerConnection(ServerName, UserName, Password);
        Server sqlServer = new Server(connection);
        Microsoft.SqlServer.Management.Smo.Server server = new Microsoft.SqlServer.Management.Smo.Server(connection);
        Database database = new Database(server, NewDatabaseName);
        database.Create();

        database.Refresh();

        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 = NewDatabaseName;

        restore.ReplaceDatabase = true;

        restore.PercentCompleteNotification = 10;

        restore.SqlRestore(server);

        database.Refresh();

        database.SetOnline();

        server.Refresh();
    }

EDIT:所有异常消息都是这样:

EDIT : All exception message is just this :

感谢您的意见....

Thanks For your advice....

推荐答案

最后我找到了一个解决方案。错误是:当您还原* .bak文件时,* .mdf和* .ldf文件将复制到特殊目录。例如:当我还原一个* .bak文件我的* .mdf和* .ldf文件复制在C:\Program Files \Microsoft SQL Server \MSSQL10_50.SQL2008RR2 \MSSQL\DATA \。所以:如果同名的* .mdf或* .ldf文件,你可以得到异常像我一样。我解决它与更改* .mdf和* .ldf文件路径。我写belov代码,它的工作。

Finally I found a solution. The error is : when you restore a *.bak file, the *.mdf and *.ldf files are copied to a special directory. Forexample : when I restore a *.bak file my *.mdf and *.ldf files copied under "C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008RR2\MSSQL\DATA\". So : If there is same name for *.mdf or *.ldf file, you can get exception like i did. And I solve it with change *.mdf and *.ldf files path. I write belov code and it's working.

C#代码是

    /// <summary>
    /// Var olan backup ın restore edilmesini sağlar
    /// </summary>
    /// <param name="NewDatabaseName">new database name</param>
    /// <param name="BackUpFile">backup file path</param>
    /// <param name="ServerName">server name</param>
    /// <param name="UserName">user name</param>
    /// <param name="Password">password</param>
    public void RestoreToDatabase(string NewDatabaseName, string BackUpFile, string ServerName, string UserName, string Password, string restorePath)
    {
        string provider = "Server    =" + ServerName +
                   ";Database =" + "master" +
                   ";User Id  =" + UserName +
                   ";password =" + Password +
                   "; Connect Timeout=2" +
                   ";Trusted_Connection=False";

        SqlConnection conn = new SqlConnection(provider);

        try
        {
            string ConnectionString = @"Data Source= " + ServerName + ";Initial Catalog=AudioMaster;Integrated Security=True";
            ServerConnection ServerConn = null;
            if (UserName == "" && Password == "")
            {
                ServerConn = new ServerConnection(ServerName);
            }
            else if (UserName != "" && Password != "")
            {
                ServerConn = new ServerConnection(ServerName, UserName, Password);
            }

            Server server = null;

            RegistryKey rk = Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft\Microsoft SQL Server");
            String[] instances = (String[])rk.GetValue("InstalledInstances");

            server = new Server(ServerConn);
        first:
            foreach (Microsoft.SqlServer.Management.Smo.Database db in server.Databases)
            {
                if (NewDatabaseName == db.Name)
                {
                    UpdateScreen("> Same database name detected", Color.Red);
                    NewDatabaseName = Microsoft.VisualBasic.Interaction.InputBox(NewDatabaseName + " database allready exist. Please enter new database name ",
                    "Database owerride error", "Enter a name");
                    UpdateScreen("> New database name : " + NewDatabaseName, Color.Green);
                    goto first;
                }
            }
        }
        catch (Exception ex)
        {
            WriteError(ex);
            UpdateScreen("> An error ocurred when database names searching operation. Details : " + ex.Message, Color.Red);
        }

        try
        {
            conn.Open();
            top :
            FileInfo file = new FileInfo(Path.Combine(dirDebug, "scriptTry.txt"));
            string mdfName = String.Empty;
            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = file.OpenText().ReadToEnd();
            cmd.Connection = conn;

            cmd.Parameters.Add("@Path", BackUpFile);

            cmd.Parameters.Add("@RestorePath", restorePath);

            cmd.Parameters.Add("@databaseName", NewDatabaseName);

            mdfName = cmd.ExecuteScalar().ToString();
            string[] names = Directory.GetFiles(restorePath, "*.mdf");

            int sayac = 0;
            for(int i=0; i<names.GetLength(0); i++)
            {
                if (mdfName == GetSubPath(names[i].Replace(".mdf", "")))
                    sayac++;
            }

            if (sayac !=0)
            {
                MessageBox.Show("Please enter new directory for database *.mdf and *.ldf file", "Database owerride error",
                MessageBoxButtons.OK, MessageBoxIcon.Exclamation);

                try
                {
                    UpdateScreen("> Same path detected for *.mdf and *.ldf file.", Color.Red);
                    FolderBrowserDialog fbd = new FolderBrowserDialog();
                    fbd.ShowDialog();
                    if (fbd.SelectedPath == "")
                        return;
                    else
                    {
                        restorePath = fbd.SelectedPath + "\\";
                    }
                    UpdateScreen("> Selected new path for *.mdf and *.ldf file : " + fbd.SelectedPath, Color.Green);
                    goto top;
                }
                catch (Exception exx)
                {
                    WriteError(exx);
                    UpdateScreen("> An error ocurred when database restore. Details : " + exx.Message, Color.Red);
                }
            }

            file = new FileInfo(Path.Combine(dirDebug, "backup script.txt"));

            cmd = new SqlCommand();

            cmd.CommandText = file.OpenText().ReadToEnd();
            cmd.Connection = conn;

            cmd.Parameters.Add("@Path", BackUpFile);

            cmd.Parameters.Add("@RestorePath", restorePath);

            cmd.Parameters.Add("@databaseName", NewDatabaseName);

            cmd.ExecuteNonQuery();

            conn.Close();
        }
        catch (Exception ex)
        {
            WriteError(ex);
        }
    }

scriptTry.txtSQL代码是:

use master

--DECLARE @Path VARCHAR(1000)= 'C:\bekap.bak',
--        @RestorePath NVARCHAR(max) = 'C:\New folder\',
--        @databaseName VARCHAR(1000)= 'isim'

DECLARE @Table TABLE
    (
      LogicalName VARCHAR(128) ,
      [PhysicalName] VARCHAR(128) ,
      [Type] VARCHAR ,
      [FileGroupName] VARCHAR(128) ,
      [Size] VARCHAR(128) ,
      [MaxSize] VARCHAR(128) ,
      [FileId] VARCHAR(128) ,
      [CreateLSN] VARCHAR(128) ,
      [DropLSN] VARCHAR(128) ,
      [UniqueId] VARCHAR(128) ,
      [ReadOnlyLSN] VARCHAR(128) ,
      [ReadWriteLSN] VARCHAR(128) ,
      [BackupSizeInBytes] VARCHAR(128) ,
      [SourceBlockSize] VARCHAR(128) ,
      [FileGroupId] VARCHAR(128) ,
      [LogGroupGUID] VARCHAR(128) ,
      [DifferentialBaseLSN] VARCHAR(128) ,
      [DifferentialBaseGUID] VARCHAR(128) ,
      [IsReadOnly] VARCHAR(128) ,
      [IsPresent] VARCHAR(128) ,
      [TDEThumbprint] VARCHAR(128)
    )

DECLARE @LogicalNameData VARCHAR(128) ,
    @LogicalNameLog VARCHAR(128)
INSERT  INTO @table
        EXEC ( '
RESTORE FILELISTONLY
   FROM DISK=''' + @Path + '''
   '
            )

DECLARE @restoreScript NVARCHAR(max)='RESTORE DATABASE [' + @databaseName + '] FROM DISK =''' + @Path + ''' WITH FILE = 1 '

SELECT  @restoreScript +=CHAR(10) + ' ,MOVE  ''' +  LogicalName + ''' TO ''' +
        @RestorePath  + LogicalName + RIGHT(PhysicalName,4) + ''''
                         FROM   @Table
                         WHERE  Type = 'D'

 SELECT  @restoreScript += ' ,MOVE  ''' +  LogicalName + ''' TO ''' + @RestorePath  + LogicalName + '.ldf'''
                        FROM    @Table
                        WHERE   Type = 'L'

SET @restoreScript += ' , NOUNLOAD, REPLACE, STATS = 10 '

--SELECT  @restoreScript
select LogicalName from @Table
--EXEC  (@restoreScript)

backup script.txtSQL代码为:

use master

--DECLARE @Path VARCHAR(1000),
--        @RestorePath NVARCHAR(max),
--        @databaseName VARCHAR(1000)

DECLARE @Table TABLE
    (
      LogicalName VARCHAR(128) ,
      [PhysicalName] VARCHAR(128) ,
      [Type] VARCHAR ,
      [FileGroupName] VARCHAR(128) ,
      [Size] VARCHAR(128) ,
      [MaxSize] VARCHAR(128) ,
      [FileId] VARCHAR(128) ,
      [CreateLSN] VARCHAR(128) ,
      [DropLSN] VARCHAR(128) ,
      [UniqueId] VARCHAR(128) ,
      [ReadOnlyLSN] VARCHAR(128) ,
      [ReadWriteLSN] VARCHAR(128) ,
      [BackupSizeInBytes] VARCHAR(128) ,
      [SourceBlockSize] VARCHAR(128) ,
      [FileGroupId] VARCHAR(128) ,
      [LogGroupGUID] VARCHAR(128) ,
      [DifferentialBaseLSN] VARCHAR(128) ,
      [DifferentialBaseGUID] VARCHAR(128) ,
      [IsReadOnly] VARCHAR(128) ,
      [IsPresent] VARCHAR(128) ,
      [TDEThumbprint] VARCHAR(128)
    )

DECLARE @LogicalNameData VARCHAR(128) ,
    @LogicalNameLog VARCHAR(128)
INSERT  INTO @table
        EXEC ( '
RESTORE FILELISTONLY
   FROM DISK=''' + @Path + '''
   '
            )

DECLARE @restoreScript NVARCHAR(max)='RESTORE DATABASE [' + @databaseName + '] FROM DISK =''' + @Path + ''' WITH FILE = 1 '

SELECT  @restoreScript +=CHAR(10) + ' ,MOVE  ''' +  LogicalName + ''' TO ''' +
        @RestorePath  + LogicalName + RIGHT(PhysicalName,4) + ''''
                         FROM   @Table
                         WHERE  Type = 'D'

 SELECT  @restoreScript += ' ,MOVE  ''' +  LogicalName + ''' TO ''' + @RestorePath  + LogicalName + '.ldf'''
                        FROM    @Table
                        WHERE   Type = 'L'

SET @restoreScript += ' , NOUNLOAD, REPLACE, STATS = 10 '

--SELECT  @restoreScript
EXEC  (@restoreScript)

这篇关于恢复数据库“服务器的恢复失败”xxx'“的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-11 10:11