saeedhushmand
شنبه 28 آبان 1390, 21:37 عصر
مشکل کد زیر چیه که هنگام بازبینی اطلاعات پشتیبانی گیری شده ارور می ده
کد
privatevoid ll_Click(object sender, EventArgs e)
{
string strFileName = string.Empty;
openFileDialog1.Filter = @"SQL Backup files (*.BAK) |*.BAK|All files
(*.*) |*.*";
openFileDialog1.FilterIndex = 1;
openFileDialog1.Title = "Restore SQL File";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
strFileName = saveFileDialog1.FileName;
Restore(strFileName);
}
}
privatevoid Restore(string strFileName)
{
try
{
string sqlcommand = "ALTER DATABASE laberator SET SINGLE_USER with ROLLBACK IMMEDIATE " + "use master" +" RESTORE DATABASE laberator FROM DISK='" + strFileName + "'";
this.Cursor = Cursors.WaitCursor;
SqlCommand oCommand = null;
SqlConnection oConnection = null;
oConnection = newSqlConnection("Data Source=.;Initial Catalog=laberator;Integrated Security=True");
if (oConnection.State != ConnectionState.Open)
oConnection.Open();
oCommand = newSqlCommand(sqlcommand, oConnection);
oCommand.ExecuteNonQuery();
this.Cursor = Cursors.Default;
MessageBox.Show("بازيابی اطلاعات از نسخه پشتيبان با موفقيت انجام شد");
}
catch (Exception ex)
{
MessageBox.Show("Error Occurd :" + ex.Message);
}
عکس ارورشم اینه
78102
بعد در کنار نام دیتابیسم در sql management می نویسه single user
کد
privatevoid ll_Click(object sender, EventArgs e)
{
string strFileName = string.Empty;
openFileDialog1.Filter = @"SQL Backup files (*.BAK) |*.BAK|All files
(*.*) |*.*";
openFileDialog1.FilterIndex = 1;
openFileDialog1.Title = "Restore SQL File";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
strFileName = saveFileDialog1.FileName;
Restore(strFileName);
}
}
privatevoid Restore(string strFileName)
{
try
{
string sqlcommand = "ALTER DATABASE laberator SET SINGLE_USER with ROLLBACK IMMEDIATE " + "use master" +" RESTORE DATABASE laberator FROM DISK='" + strFileName + "'";
this.Cursor = Cursors.WaitCursor;
SqlCommand oCommand = null;
SqlConnection oConnection = null;
oConnection = newSqlConnection("Data Source=.;Initial Catalog=laberator;Integrated Security=True");
if (oConnection.State != ConnectionState.Open)
oConnection.Open();
oCommand = newSqlCommand(sqlcommand, oConnection);
oCommand.ExecuteNonQuery();
this.Cursor = Cursors.Default;
MessageBox.Show("بازيابی اطلاعات از نسخه پشتيبان با موفقيت انجام شد");
}
catch (Exception ex)
{
MessageBox.Show("Error Occurd :" + ex.Message);
}
عکس ارورشم اینه
78102
بعد در کنار نام دیتابیسم در sql management می نویسه single user