Rahimiyan
سه شنبه 24 اسفند 1389, 12:07 عصر
سلام
وقتی می خوام ریستور کنم خطای زیر رو می ده کمکم کنید.
RESTORE DATABASE is terminating abnormally.
Changed database context to 'master'.
کد Backup:
@"BACKUP DATABASE [DBName]TO DISK=N'C:\\bac.bak' WITH NOFORMAT,NOINIT,NAME=N'mydb-full Database Backup',SKIP,NOREWIND,NOUNLOAD,STATS=10;";
کد restore:
string t = @"USE master; RESTORE DATABASE [ dbName ] FROM DISK =N'C:\data\ba.bak'";
SqlConnection objcon = new SqlConnection(@"Data Source=.\SQLExpressdatabase=master;Integrated Security=True;User Instance=True;");
SqlCommand objcom = new SqlCommand(t, objcon);
try
{
objcon.Open();
objcom.ExecuteNonQuery();
objcon.Close();
}
catch ()
{
objcon.Close();
return false;
}
وقتی می خوام ریستور کنم خطای زیر رو می ده کمکم کنید.
RESTORE DATABASE is terminating abnormally.
Changed database context to 'master'.
کد Backup:
@"BACKUP DATABASE [DBName]TO DISK=N'C:\\bac.bak' WITH NOFORMAT,NOINIT,NAME=N'mydb-full Database Backup',SKIP,NOREWIND,NOUNLOAD,STATS=10;";
کد restore:
string t = @"USE master; RESTORE DATABASE [ dbName ] FROM DISK =N'C:\data\ba.bak'";
SqlConnection objcon = new SqlConnection(@"Data Source=.\SQLExpressdatabase=master;Integrated Security=True;User Instance=True;");
SqlCommand objcom = new SqlCommand(t, objcon);
try
{
objcon.Open();
objcom.ExecuteNonQuery();
objcon.Close();
}
catch ()
{
objcon.Close();
return false;
}