public static void RestoreBackup(string filePath)
{
try
{
string Query = string.Empty;
Query = "USE [master]" + Environment.NewLine;
Query += "ALTER DATABASE EBusiness" + Environment.NewLine;
Query += "SET SINGLE_USER WITH" + Environment.NewLine;
Query += "ROLLBACK IMMEDIATE" + Environment.NewLine;
Query += "RESTORE DATABASE EBusiness FROM DISK = '" + filePath + "' WITH REPLACE" + Environment.NewLine;
Query += "ALTER DATABASE EBusiness SET MULTI_USER" + Environment.NewLine;
DataAccessManager dam = new DataAccessManager();
//dam.ExecuteNonQuery(CommandType.Text, Query);
dam.ExecuteNonQueryOnMaster(CommandType.Text, Query);
}
catch (Exception ex)
{
throw;
}
}