How to troubleshoot "Problems with the query, "ResultSet" property not set correctly"?

CharlieLor 551 Reputation points
2024-02-04T18:40:35.3666667+00:00

My transaction log backup maintenance plan keep failing with the following error.

Executing the query "BACKUP DATABASE [TnDb] TO DISK = N'E:\Logs\Tn..." failed with the following error: "Write on "E:\Logs\TnDb\ TnDb_backup_2024_02_04_112623_1927552.trn" failed: 112(There is not enough space on the disk.)BACKUP DATABASE is terminating abnormally.10 percent processed.20 percent processed.30 percent processed.40 percent processed.50 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Is this a case of not enough disk space on the "E" drive? What is a "ResultSet" property not set to correctly means?

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

Accepted answer
  1. Erland Sommarskog 99,626 Reputation points MVP
    2024-02-04T19:16:05.74+00:00

    Yes, you are short on disk space on the E: Drive. The verbiage about query, ResultSet etc is some general text from the maintenance plan or Agent, and nothing to do with the backup failure. Just ignore that part.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. ZoeHui-MSFT 30,881 Reputation points
    2024-02-05T05:18:44.7033333+00:00

    Hi @CharlieLor,

    There is not enough space on the disk

    The issue is clear that you do not have enough space on your driver. ResultSet specify the result type expected by the SQL statement being run.

    See: https://stackoverflow.com/questions/19922561/what-is-the-difference-between-a-result-set-and-return-value-in-a-sql-procedure

    In addition, The Maintenance Cleanup task does not automatically delete files in the subfolders of the specified directory. This feature reduces the possibility of a malicious attack that uses the Maintenance Cleanup task to delete files. If you want to delete files in first-level subfolders, you must select Include first-level subfolders.

    Check Maintenance Cleanup Task (Maintenance Plan)

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.