mohsenm66
شنبه 10 دی 1390, 15:56 عصر
دوستان من برای بکاپ و ریستور کردن پایگاه داده ام در سایت جستجو کردم و به یکسری جواب هایی رسیدم و آنها را در برنامه ام استفاده کردم ولی با خطا روبرو شده ام . از کلیه دوستان برنامه نویس تقاضا دارم در رفع خطا به من کمک کنند.
من از VB.Net 2010 و SQL Server 2008 R2 استفاده کرده ام
کد بکاپ :
Dim cn As New System.Data.SqlClient.SqlConnection(cs)
Dim cmd As New System.Data.SqlClient.SqlCommand
cn.Open()
Dim query As String = "BACKUP DATABASE mali TO DISK = N'" + filename + "'"
cmd.CommandText = query
cmd.Connection = cn
cmd.ExecuteNonQuery()
cn.Close()
متن خطا :
Cannot open backup device 'C:\Users\mohsen\Desktop\mali_13901010_12_12.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
BACKUP DATABASE is terminating abnormally.
کد restore :
con.Open()
Dim query As String = "USE master RESTORE DATABASE mali FROM DISK = N'" + filename + "'"
cmd.CommandText = query
cmd.Connection = con
cmd.ExecuteNonQuery()
con.Close()
MessageBox.Show("بازيابي با موفقيت انجام شد")
متن خطا :
The tail of the log for the database "mali" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log.
RESTORE DATABASE is terminating abnormally.
Changed database context to 'master'.
من از VB.Net 2010 و SQL Server 2008 R2 استفاده کرده ام
کد بکاپ :
Dim cn As New System.Data.SqlClient.SqlConnection(cs)
Dim cmd As New System.Data.SqlClient.SqlCommand
cn.Open()
Dim query As String = "BACKUP DATABASE mali TO DISK = N'" + filename + "'"
cmd.CommandText = query
cmd.Connection = cn
cmd.ExecuteNonQuery()
cn.Close()
متن خطا :
Cannot open backup device 'C:\Users\mohsen\Desktop\mali_13901010_12_12.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
BACKUP DATABASE is terminating abnormally.
کد restore :
con.Open()
Dim query As String = "USE master RESTORE DATABASE mali FROM DISK = N'" + filename + "'"
cmd.CommandText = query
cmd.Connection = con
cmd.ExecuteNonQuery()
con.Close()
MessageBox.Show("بازيابي با موفقيت انجام شد")
متن خطا :
The tail of the log for the database "mali" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log.
RESTORE DATABASE is terminating abnormally.
Changed database context to 'master'.