سلام دوستان
من برای Restor کردن از کد زیر استفاده میکنم :
string sql = "ALTER DATABASE [" + Application.StartupPath + "\\DB.mdf] SET SINGLE_USER with ROLLBACK IMMEDIATE use master RESTORE DATABASE [" + Application.StartupPath + "\\DB.mdf] FROM DISK='" + textBox2.Text + "'";
و این خطا رو میده :
User does not have permission to alter database , the database does not exist, or the database is not in a state that allows access checks.ALTER DATABASE statement failed.
The file 'Db.mdf' cannot be overwritten. It is being used by database DB.MDF'.
File 'DB' cannot be restored to 'DB.mdf'. Use WITH MOVE to identify a valid location for the file.
The file 'DB_log.ldf' cannot be overwritten. It is being used by database 'DB.MDF'.
File 'DB_log' cannot be restored to 'DB_log.ldf'. Use WITH MOVE to identify a valid location for the file.
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
RESTORE DATABASE is terminating abnormally.
Changed database context to 'master'.
اساتید لطفا کمک کنید , هر راهی رو امتحان کردم جواب نداد که نداد, ممنون.
پاسخ با نقل قول
