samaram
چهارشنبه 25 آذر 1388, 19:53 عصر
من این کد رو برای ریستور کردن دیتابیسم نوشتم. ولی وقتی اجرا می کنم با این خطا مواجه میشم:
http://up.iranblog.com/5/1260983138.bmp
private void toolStripMenuItem4_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
try
{
if (File.Exists(@"c:\SQLBackup\wcBackUp1.bak"))
{
if (MessageBox.Show("Are you sure you restore?", "Back", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
//Connect SQL-----------
SqlConnection connect;
string con = "Data Source = .\\SQLEXPRESS; Initial Catalog=Tanin ;Integrated Security = True;";
connect = new SqlConnection(con);
connect.Open();
//-----------------------------------------------------------------------------------------
//Excute SQL----------------
SqlCommand command;
command = new SqlCommand("use Tanin", connect);
command.ExecuteNonQuery();
command = new SqlCommand(@"restore database Tanin from disk = 'c:\SQLBackup\wcBackUp1.bak'", connect);
command.ExecuteNonQuery();
//--------------------------------------------------------------------------------------------------------
connect.Close();
MessageBox.Show("Has been restored database", "Restoration", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
MessageBox.Show(@"Do not make any endorsement above (or is not in the correct path)", "Restoration", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
اسم دیتابیسم Tanin هستش. و در اس اکیو ال 2005 کار می کنم
http://up.iranblog.com/5/1260983138.bmp
private void toolStripMenuItem4_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
try
{
if (File.Exists(@"c:\SQLBackup\wcBackUp1.bak"))
{
if (MessageBox.Show("Are you sure you restore?", "Back", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
//Connect SQL-----------
SqlConnection connect;
string con = "Data Source = .\\SQLEXPRESS; Initial Catalog=Tanin ;Integrated Security = True;";
connect = new SqlConnection(con);
connect.Open();
//-----------------------------------------------------------------------------------------
//Excute SQL----------------
SqlCommand command;
command = new SqlCommand("use Tanin", connect);
command.ExecuteNonQuery();
command = new SqlCommand(@"restore database Tanin from disk = 'c:\SQLBackup\wcBackUp1.bak'", connect);
command.ExecuteNonQuery();
//--------------------------------------------------------------------------------------------------------
connect.Close();
MessageBox.Show("Has been restored database", "Restoration", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
MessageBox.Show(@"Do not make any endorsement above (or is not in the correct path)", "Restoration", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
اسم دیتابیسم Tanin هستش. و در اس اکیو ال 2005 کار می کنم