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

ความคิดเห็น • 8

  • @Curationz
    @Curationz 2 หลายเดือนก่อน +1

    your the man thanks dude really helped me out fixing one of our servers :)

  • @nandinipundipandu6163
    @nandinipundipandu6163 5 วันที่ผ่านมา

    I'm getting 'RECOVERY PENDING' besidw the db name & not able to open it

  • @balajis1873
    @balajis1873 10 หลายเดือนก่อน +3

    Hats off to you bro really thanks

  • @iaralopes5866
    @iaralopes5866 หลายเดือนก่อน +1

    tank you!!

  • @kumarshubham5215
    @kumarshubham5215 8 หลายเดือนก่อน +2

    ty bro😍

  • @My_Music-Comedy_Channel
    @My_Music-Comedy_Channel 5 หลายเดือนก่อน +2

    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

    • @Curationz
      @Curationz 2 หลายเดือนก่อน +1

      thanks for the message on renaming the log had to do that as well

    • @ajithkumar.g7834
      @ajithkumar.g7834 14 วันที่ผ่านมา +1

      Thank bro ...I got it