Fix sql error when restoring bak files
Budget: $10 – $30 USD
Hi, I am looking for someone to help with a problem I am facing when trying to restore bak files in a Windows environment. The bak files are created from an MS SQL database, and the challenge is that no matter what I am doing, I keep getting SQL error messages.
I need someone to help me troubleshoot the issue and deploy the changes necessary to get the restore working. Ideally, I need someone with a good knowledge of MS SQL and Windows as it’s a two-part job of resolving the environment issue and making the necessary changes in the code. Bonus points if you have experience of similar projects.
This is a paid project, so please bid only if you are confident of being able to provide the required solution in a timely manner. I look forward to receiving your bids. Thank you!
This is the error:
RESTORE DATABASE [ADD_Catalogos] FROM DISK = 'C:\test\ADD_Catalogos_20230406.BAK' WITH FILE=1,REPLACE, MOVE 'ADD_Catalogos' TO 'C:\Program Files\Microsoft SQL Server\MSSQL12.COMPAC\MSSQL\DATA\ADD_Catalogos.mdf', MOVE 'ADD_Catalogos_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL12.COMPAC\MSSQL\DATA\ADD_Catalogos_log.ldf'
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL12.COMPAC\MSSQL\DATA\ADD_Catalogos.mdf" failed with the operating system error 3(El sistema no puede encontrar la ruta especificada.).
Msg 3156, Level 16, State 3, Line 1
File 'ADD_Catalogos' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL12.COMPAC\MSSQL\DATA\ADD_Catalogos.mdf'. Use WITH MOVE to identify a valid location for the file.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL12.COMPAC\MSSQL\DATA\ADD_Catalogos_log.ldf" failed with the operating system error 3(El sistema no puede encontrar la ruta especificada.).
Msg 3156, Level 16, State 3, Line 1
File 'ADD_Catalogos_log' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL12.COMPAC\MSSQL\DATA\ADD_Catalogos_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.
I need someone to help me troubleshoot the issue and deploy the changes necessary to get the restore working. Ideally, I need someone with a good knowledge of MS SQL and Windows as it’s a two-part job of resolving the environment issue and making the necessary changes in the code. Bonus points if you have experience of similar projects.
This is a paid project, so please bid only if you are confident of being able to provide the required solution in a timely manner. I look forward to receiving your bids. Thank you!
This is the error:
RESTORE DATABASE [ADD_Catalogos] FROM DISK = 'C:\test\ADD_Catalogos_20230406.BAK' WITH FILE=1,REPLACE, MOVE 'ADD_Catalogos' TO 'C:\Program Files\Microsoft SQL Server\MSSQL12.COMPAC\MSSQL\DATA\ADD_Catalogos.mdf', MOVE 'ADD_Catalogos_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL12.COMPAC\MSSQL\DATA\ADD_Catalogos_log.ldf'
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL12.COMPAC\MSSQL\DATA\ADD_Catalogos.mdf" failed with the operating system error 3(El sistema no puede encontrar la ruta especificada.).
Msg 3156, Level 16, State 3, Line 1
File 'ADD_Catalogos' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL12.COMPAC\MSSQL\DATA\ADD_Catalogos.mdf'. Use WITH MOVE to identify a valid location for the file.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL12.COMPAC\MSSQL\DATA\ADD_Catalogos_log.ldf" failed with the operating system error 3(El sistema no puede encontrar la ruta especificada.).
Msg 3156, Level 16, State 3, Line 1
File 'ADD_Catalogos_log' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL12.COMPAC\MSSQL\DATA\ADD_Catalogos_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.