saeedhushmand
دوشنبه 09 آبان 1390, 23:23 عصر
کد زیر که برای بازبینی پشتیبانی دیتابیسم هنگام بازبینی دیتابیس تو برنامه ارور میده
کدش اینه
private void DB_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);
}
}
private void Restore(string strFileName)
{
try
{
string command = "ALTER DATABASE laberator SET SINGLE_USER with ROLLBACKIMMEDIATE " +"use master " +" RESTORE DATABASE laberator FROM DISK='" + strFileName + "'";
this.Cursor = Cursors.WaitCursor;
SqlCommand oCommand = null;
SqlConnection oConnection = null;
oConnection = new SqlConnection("SERVER=.;DATABASE=laberator;Integrated Security=True");
if (oConnection.State != ConnectionState.Open)
oConnection.Open();
oCommand = new SqlCommand(command, oConnection);
oCommand.ExecuteNonQuery();
this.Cursor = Cursors.Default;
MessageBox.Show("بازيابی اطلاعات از نسخه پشتيبان با موفقيت انجام شد");
}
catch (Exception ex)
{
MessageBox.Show("Error Occurd :" + ex.Message);
}
}
ارورشم که هنگام بازبینی می ده اینه
Error Occurd :Incorrect syntax near 'ROLLBACKIMMEDIATE
کدش اینه
private void DB_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);
}
}
private void Restore(string strFileName)
{
try
{
string command = "ALTER DATABASE laberator SET SINGLE_USER with ROLLBACKIMMEDIATE " +"use master " +" RESTORE DATABASE laberator FROM DISK='" + strFileName + "'";
this.Cursor = Cursors.WaitCursor;
SqlCommand oCommand = null;
SqlConnection oConnection = null;
oConnection = new SqlConnection("SERVER=.;DATABASE=laberator;Integrated Security=True");
if (oConnection.State != ConnectionState.Open)
oConnection.Open();
oCommand = new SqlCommand(command, oConnection);
oCommand.ExecuteNonQuery();
this.Cursor = Cursors.Default;
MessageBox.Show("بازيابی اطلاعات از نسخه پشتيبان با موفقيت انجام شد");
}
catch (Exception ex)
{
MessageBox.Show("Error Occurd :" + ex.Message);
}
}
ارورشم که هنگام بازبینی می ده اینه
Error Occurd :Incorrect syntax near 'ROLLBACKIMMEDIATE