Restore of database failed. File cannot be restored over the existing. -[SOLVED]
ฝัง
- เผยแพร่เมื่อ 17 เม.ย. 2023
- When I was tried to restore the database but the restore of database is failed and showing the following error message.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore of database 'ShoppingZone' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: File "ShoppingZone" cannot be restored over the existing "C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\ShoppingZone.mdf". Reissue the RESTORE statement using WITH REPLACE to overwrite pre-existing files, or WITH MOVE to identify an alternate location. (Microsoft.SqlServer.SmoExtended)
For help, click: go.microsoft.com/fwlink?ProdN...
------------------------------
BUTTONS:
OK
------------------------------
www.infinetsoft.com/Post/Resto...
✅Subscribe: th-cam.com/users/infinetsoftso...
✅Blog: www.infinetsoft.com, ✅Tech:chiptrolls.com
✅ Twitter: / infinetsoft
your the man thanks dude really helped me out fixing one of our servers :)
I'm getting 'RECOVERY PENDING' besidw the db name & not able to open it
Hats off to you bro really thanks
tank you!!
ty bro😍
Thank you so much. At first, it' didn't work. But then I noticed that even the log file should be renamed to log_1 for the restore to work
thanks for the message on renaming the log had to do that as well
Thank bro ...I got it