MagicMirror Forum
    • Recent
    • Tags
    • Unsolved
    • Solved
    • MagicMirror² Repository
    • Documentation
    • 3rd-Party-Modules
    • Donate
    • Discord
    • Register
    • Login
    1. Home
    2. rogermathew
    A New Chapter for MagicMirror: The Community Takes the Lead
    Read the statement by Michael Teeuw here.
    R
    Offline
    • Profile
    • Following 0
    • Followers 0
    • Topics 1
    • Posts 1
    • Groups 0

    rogermathew

    @rogermathew

    0
    Reputation
    261
    Profile views
    1
    Posts
    0
    Followers
    0
    Following
    Joined
    Last Online

    rogermathew Unfollow Follow

    Latest posts made by rogermathew

    • 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

      posted in Development
      R
      rogermathew