Error 3154 – Restore SQL database is terminating abnormally

[rogermathew]

Hello Experts,

Our team is developing a module which takes data from SQL Sever database 2014 and shows the data on Magic Mirror screen. We are in trouble while accessing database, all data not show on the screen. The, we tried to restore SQL database and face SQL Error 3154. To fix this kind of error, we are tried T-SQL command but no result found. Then we try to use WITH REPLACE while using restore script.

RESTORE FILELISTONLY
FROM DISK = 'C:\company_file.bak'
GO
 
RESTORE DATABASE company_file
FROM DISK = 'C\:company_file.bak'
WITH MOVE 'company_file_Data' TO 'C:\Database\company_file.mdf',
MOVE 'companyfile_Log' TO 'C:\Database\companyfile.ldf',
REPLACE

After executing these commands we are still facing error. Then someone suggested me to use below resources, but we are confused which one is better.
Please provide full proof method.
https://forum.magicmirror.builders/topic/6803/magicmirror-to-mssql
https://www.essentialsql.com/error-3154-restore-sql-database/
https://www.stellarinfo.com/sql-recovery.php

[nourimane]

@rogermathew said in Error 3154 – Restore SQL database is terminating abnormally:

Hello Experts,

Our team is developing a module which takes data from SQL Sever database 2014 and shows the data on Magic Mirror screen. We are in trouble while accessing database, all data not show on the screen. The, we tried to restore SQL database and face SQL Error 3154. To fix this kind of error, we are tried T-SQL command but no result found. Then we try to use WITH REPLACE while using restore script.

RESTORE FILELISTONLY
FROM DISK = 'C:\company_file.bak'
GO
 
RESTORE DATABASE company_file
FROM DISK = 'C\:company_file.bak'
WITH MOVE 'company_file_Data' TO 'C:\Database\company_file.mdf',
MOVE 'companyfile_Log' TO 'C:\Database\companyfile.ldf',
REPLACE

After executing these commands we are still facing error. Then someone suggested me to use below resources, but we are confused which one is better.
Please provide full proof method.
https://forum.magicmirror.builders/topic/6803/magicmirror-to-mssql
https://www.essentialsql.com/error-3154-restore-sql-database/
https://www.stellarinfo.com/sql-recovery.php

I have no idea, but I have a suggestion :
Create a proxy service, so you donot have to access database directly but a distant service.
This last will access the database. You can use the platform you want especially .Net technology which is very easy to integrate with SQL Server.