Restore of database failed. File cannot be restored over the existing. -[SOLVED]
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 FilesMicrosoft SQL ServerMSSQL15.SQLEXPRESSMSSQLDATAShoppingZone.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: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.46437.65+(SMO-master-A)&LinkId=20476
——————————
BUTTONS:
OK
——————————
http://www.infinetsoft.com/Post/Restore-of-database-failed-File-cannot-be-restored-over-the-existing-SOLVED/3156
✅Subscribe: https://www.youtube.com/infinetsoftsolutions?sub_confirmation=1
✅Blog: https://www.infinetsoft.com, ✅Tech:https://chiptrolls.com
✅ Twitter: https://twitter.com/infinetsoft
Comments are closed.