Ehsan_seif
شنبه 15 آبان 1389, 12:43 عصر
با سلام خدمت دوستان
من یه بک آپ از دیتا بیسم گرفتم اما حالا واسه برگردوندنش به مشکل برخوردم
واسه Restore کردن از دستور زیر استفاده کردم
USE master; RESTORE DATABASE [F:\Sandugh.mdf] FROM DISK = @address WITH REPLACE
ولی موقع Restore کردن این خطا رو میده
Msg 1834, Level 16, State 1, Line 1
The file 'F:\Sandugh.mdf' cannot be overwritten. It is being used by database 'active Sandough'.
Msg 3156, Level 16, State 4, Line 1
File 'Sandughe Khanevadegi' cannot be restored to 'F:\Sandugh.mdf'. Use WITH MOVE to identify a valid location for the file.
Msg 1834, Level 16, State 1, Line 1
The file 'F:\Sandugh_log.ldf' cannot be overwritten. It is being used by database 'active Sandough'.
Msg 3156, Level 16, State 4, Line 1
File 'Sandughe Khanevadegi_log' cannot be restored to 'F:\Sandugh_log.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
کسی با این مشکل برخورد کرده؟
هیچ کس می تونه کمکم کنه؟
من یه بک آپ از دیتا بیسم گرفتم اما حالا واسه برگردوندنش به مشکل برخوردم
واسه Restore کردن از دستور زیر استفاده کردم
USE master; RESTORE DATABASE [F:\Sandugh.mdf] FROM DISK = @address WITH REPLACE
ولی موقع Restore کردن این خطا رو میده
Msg 1834, Level 16, State 1, Line 1
The file 'F:\Sandugh.mdf' cannot be overwritten. It is being used by database 'active Sandough'.
Msg 3156, Level 16, State 4, Line 1
File 'Sandughe Khanevadegi' cannot be restored to 'F:\Sandugh.mdf'. Use WITH MOVE to identify a valid location for the file.
Msg 1834, Level 16, State 1, Line 1
The file 'F:\Sandugh_log.ldf' cannot be overwritten. It is being used by database 'active Sandough'.
Msg 3156, Level 16, State 4, Line 1
File 'Sandughe Khanevadegi_log' cannot be restored to 'F:\Sandugh_log.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
کسی با این مشکل برخورد کرده؟
هیچ کس می تونه کمکم کنه؟