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