PDA

View Full Version : مشکل ری استور کردن



beheshtmahmood
سه شنبه 29 شهریور 1390, 12:15 عصر
سلام پروژه ای با ado.net نوشتم.برای ری استور کردن دیتابیس به این مشکل برخوردم.
User does not have permission to alter database 'alaki' or the database does not exist.
ALTER DATABASE statement failed.
کدمم اینه
try
{
string con= @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\alaki.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
SqlConnection connect = new SqlConnection(con);
SqlCommand cmd = new SqlCommand();
connect.Open();
string s1 = "ALTER DATABASE alaki SET OFFLINE WITH ROLLBACK IMMEDIATE";
string s2 = "ALTER DATABASE alaki SET MULTI_USER";
string query = "RESTORE DATABASE alaki FROM DISK ='" + path + "'" + "WITH FILE = 1, KEEP_REPLICATION, NOUNLOAD, REPLACE, STATS = 10";

cmd.CommandText = s1;
cmd.Connection = connect;
cmd.ExecuteNonQuery();
cmd.CommandText = s2;
cmd.Connection = connect;
cmd.ExecuteNonQuery();
cmd.CommandText = query;
cmd.Connection = connect;
cmd.ExecuteNonQuery();
connect.Close();
MessageBox.Show("restor ");
}
catch (Exception ex)
{
MessageBox.Show(" ");
MessageBox.Show(ex.Message);
مشکلش از چیه؟:متفکر: