| عناوین بحث ها | ارسال کننده | پاسخها | بازدید | بروز رسانی | اولویت | |
|---|---|---|---|---|---|---|
|
|
40
|
915
|
91/2/18 (10:42)
|
|
||
|
|
34
|
954
|
90/11/30 (14:32)
|
|
||
|
|
5
|
445
|
90/5/10 (13:54)
|
|
||
|
|
3
|
13
|
91/3/10 (02:32)
|
|
||
|
|
3
|
39
|
91/3/6 (22:39)
|
|
||
|
|
2
|
4
|
91/3/2 (23:20)
|
|
||
|
|
0
|
3
|
91/2/30 (14:23)
|
|
||
|
|
11
|
26
|
91/2/24 (07:33)
|
|
||
|
|
2
|
7
|
91/2/18 (11:53)
|
|
||
|
|
0
|
0
|
91/2/4 (14:55)
|
|
||
|
|
1
|
4
|
91/2/3 (13:41)
|
|
||
|
|
4
|
6
|
91/2/3 (13:40)
|
|
||
|
|
0
|
4
|
91/2/2 (13:44)
|
|
||
|
|
0
|
9
|
91/1/25 (17:52)
|
|
||
|
|
2
|
34
|
91/1/18 (20:10)
|
|
||
|
|
2
|
11
|
90/12/26 (20:40)
|
|
||
|
|
1
|
10
|
90/12/22 (14:18)
|
|
||
|
|
3
|
17
|
90/12/22 (14:16)
|
|
||
|
|
2
|
21
|
90/12/19 (16:34)
|
|
||
|
|
0
|
6
|
90/12/15 (21:22)
|
|
سلام یه پروژه نوشتم با سی شارپ و ado برا ری استور کردنش مشکل دارم.کسی میتونم کمکم کنه؟
try{
string con= @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\alaki.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; SqlConnection connect = newSqlConnection(con); SqlCommand cmd = newSqlCommand();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);این اررور رو میگیره:
User does not have permission to alter database 'alaki' or the database does not exist.
ALTER DATABASE statement failed.
