PDA

View Full Version : مشکل در Restore کردن



park_1365
یک شنبه 03 مهر 1390, 20:49 عصر
سلام دوستان بنده در Vb.net 2008 با این کانکشن و این کد بدون خطا از بانک پک آپ می گیریم


Dim strcon As String = "Data Source=.\SQLEXPRESS;AttachDBFilename=|DataDirector y|File.mdf;Integrated Security=True;User Instance=True"

و


Dim command As String = "backup database [" + dbname + "] to disk='" + strfilename + "'"

حال وقتی می خواهم این فایل رو با این کدها Restore کنم خطای زیر را می گیرد


Dim cmd As New SqlCommand





cmd.Connection = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|File.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")

cmd.Connection.Open()

Dim dbname As String = cmd.Connection.Database


cmd.Connection.Close()


Dim query As String = "ALTER DATABASE [" + dbname + "] SET SINGLE_USER WITH ROLLBACK IMMEDIATE ;RESTORE DATABASE [" + dbname + "] FROM DISK = '" + strfilename + "';ALTER DATABASE [" + dbname + "] SET MULTI_USER ;"

cmd.Connection = New SqlConnection("Data Source=.\sqlexpress;Integrated Security=True;Connect Timeout=30;User Instance=True")

cmd.Connection.Open()

cmd.CommandText = query

cmd.ExecuteNonQuery()

cmd.Connection.Close()


پیغام خطا
The tail of the log for the database "Filename" 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. Nonqualified transactions are being rolled back. Estimated rollback completion: