在Asp.Net，C＃中由管理员用户备份和还原Sql数据库， [英] BackUp and Restore Sql Database By Admin User in Asp.Net, C#,

问题描述

在这里，我已经使用Sql Database显示了BackUp和Restore的c＃代码，因为备份工作正常但是当我尝试从备份文件夹恢复数据库时，那时发生了一个错误，错误是：

RESTORE无法处理数据库&＃39; UsersDB&＃39;因为它在本次会议中使用。建议在执行此操作时使用master数据库。

RESTORE DATABASE异常终止。

Here, I have show my c# code for BackUp and Restore with Sql Database, in that back up is working properly but when i try to restore the database from backup folder, that time one error is occurred, and the error is:
RESTORE cannot process database 'UsersDB' because it is in use by this session. It is recommended that the master database be used when performing this operation.
RESTORE DATABASE is terminating abnormally.

protected void btnbackup_Click(object sender, EventArgs e)
    {
        sqlcon.ConnectionString = (System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ToString());
        string destdir = "C:\\backupdb";
        if (!System.IO.Directory.Exists(destdir))
        {
            System.IO.Directory.CreateDirectory("C:\\backupdb");
        }
        try
        {
            sqlcon.Open();
            sqlcmd = new SqlCommand("backup database UsersDB to disk='" + destdir + "\\" + DateTime.Now.ToString("ddMMyyyy_HHmmss") + ".Bak'", sqlcon);
            sqlcmd.ExecuteNonQuery();
            Response.Write("Backup database successfully");
        }
        catch (Exception ex)
        {
            Response.Write("Error During backup database!");
        }
    }

protected void btnrestore_Click(object sender, EventArgs e)
   {
       //try
       //{


       sqlcon.ConnectionString = (System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ToString());
       sqlcon.Open();
       string destdir = "C:\\backupdb\\11082014_121403.Bak";

       sqlcmd = new SqlCommand("Restore database UsersDB from disk='C:11082014_143650.Bak' ", sqlcon);
       sqlcmd.ExecuteNonQuery();
       Response.Write("restore database successfully");
       //}
       //catch (Exception ex)
       //{
       //    Response.Write("Error During backup database!");
       //}


   }

推荐答案

请参阅此

error-restore-cannot-process-database- test-db-because-it-it-use-by-this-se [ ^ ]



错误显示全部..在进行备份之前，将其转换为主（使用主）然后进行备份。



希望它会有所帮助..

Refer this
error-restore-cannot-process-database-test-db-because-it-is-in-use-by-this-se[^]

The error shows it all.. before taking backup, shift it to master (use master) and then take the backup.

Hope it will help..

你好



默认创建的数据库是为多用户创建的。在执行还原操作时，您应该为单个用户创建数据库。





使用C＃和.NET 2.0进行SQL Server 2005数据库备份和还原 [ ^ ]



或



SQL Server 2008 - 使用SMO备份和还原数据库 [ ^ ]

这篇关于在Asp.Net，C＃中由管理员用户备份和还原Sql数据库，的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！