MagicMirror Forum

    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unsolved
    • Solved
    • MagicMirror² Repository
    • Documentation
    • Donate
    • Discord
    MagicMirror² v2.25.0 is available! For more information about this release, check out this topic.

    Error 3154 – Restore SQL database is terminating abnormally

    Development
    2
    2
    727
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • R
      rogermathew last edited by 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

      N 1 Reply Last reply Reply Quote 0
      • N
        nourimane @rogermathew last edited by

        @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.

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        • First post
          Last post
        Enjoying MagicMirror? Please consider a donation!
        MagicMirror created by Michael Teeuw.
        Forum managed by Paul-Vincent Roll and Rodrigo Ramírez Norambuena.
        This forum is using NodeBB as its core | Contributors
        Contact | Privacy Policy