Backup Database is terminating abnormally

Ransford Graham 1 Reputation point
2022-11-01T00:22:50.753+00:00

If I run the backup stored procedure from SSMS query window it completes successfully.

If I call the backup stored procedure from FoxPro SQL Pass Through I get the message 'Backup Database is terminating abnormally'

What could be the cause?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
{count} votes

2 answers

Sort by: Most helpful
  1. CathyJi-MSFT 21,111 Reputation points Microsoft Vendor
    2022-11-01T02:23:09.133+00:00

    Hi @Ransford Graham ,

    If the stored procedure works well in SSMS, then there is no issue with SQL server procedure. This issue may related to some limits that calling SQL procedure in FoxPro SQL Pass Through. Suggest you post your issue on FoxPro Forum for better help.

    In addition, the error message that you offered is too less for analysis. Please share more related error message from SQL server error log and application log to get better help.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments

  2. Erland Sommarskog 103.8K Reputation points MVP
    2022-11-01T22:58:15.627+00:00

    When BACKUP fails, ir produces two messages as in this example:

    Msg 3201, Level 16, State 1, Line 1

    Cannot open backup device 'K:\Nosuchdisk\backup.bak'. Operating system error 3(The system cannot find the path specified.).

    Msg 3013, Level 16, State 1, Line 1

    BACKUP DATABASE is terminating abnormally.

    It appears that for some reason FoxPro only give you the last error message. But you need to get hold of the first error message to find out what is going on.

    One way to do this is use Profiler, and include the event Error:Exception in your trace, so you can get the error message.

    0 comments No comments