{"id":164901,"date":"2025-05-19T10:33:50","date_gmt":"2025-05-19T17:33:50","guid":{"rendered":"https:\/\/blog.everpuredata.com\/?p=164901"},"modified":"2025-06-17T07:57:26","modified_gmt":"2025-06-17T14:57:26","slug":"sql-server-2025-streamlining-t-sql-snapshot-backups","status":"publish","type":"post","link":"https:\/\/blog.everpuredata.com\/zh-hant\/purely-technical\/sql-server-2025-streamlining-t-sql-snapshot-backups\/","title":{"rendered":"SQL Server 2025 \u4e2d\u7684 T-SQL REST API \u6574\u5408\uff1a\u7c21\u5316 T-SQL \u5feb\u7167\u5099\u4efd"},"content":{"rendered":"\n
\n
\n
\n

\u7e3d\u7d50<\/h3>\n\n\n\n

This article takes you through the steps for using a T-SQL script to create application-consistent snapshots on <\/sup>FlashArray from within SQL Server, without needing any external tools or scripts.\u00a0<\/p>\n<\/div>\n\n\n\n

\"image_pdf\"<\/a>\"image_print\"<\/a><\/div>\n<\/div>\n\n\n\n
\n

\u672c\u6587\u6700\u521d\u51fa\u73fe\u5728 Anthony Nocentino \u7684\u90e8\u843d\u683c<\/a>\u4e0a\u3002\u7d93\u4f5c\u8005\u7684\u8a8d\u53ef\u8207\u540c\u610f\uff0c\u91cd\u65b0\u767c\u8868\u3002<\/em><\/p>\n\n\n\n

\u5728\u9019\u7bc7\u6587\u7ae0\u4e2d\uff0c\u6211\u6703\u5e36\u60a8\u4e86\u89e3 T-SQL \u8173\u672c\uff0c\u5728 Pure Storage\u00ae <\/sup>FlashArray<\/a> <\/sup>\u4e0a\u5efa\u7acb\u61c9\u7528\u7a0b\u5f0f\u4e00\u81f4\u7684\u5feb\u7167\uff0c\u6240\u6709\u5167\u5bb9\u90fd\u4f86\u81ea SQL Server\uff0c\u7121\u9700\u5916\u90e8\u5de5\u5177\u3002SQL Server 2025 \u63a8\u51fa\u5f37\u5927\u7684\u65b0\u529f\u80fd\uff1asp_invoke_external_rest_endpoint<\/em>\u5132\u5b58\u7a0b\u5e8f\u3002\u9019\u9805\u589e\u5f37\u529f\u80fd\u8b93\u76f4\u63a5\u5f9e T-SQL \u547c\u53eb REST API \u8b8a\u5f97\u6bd4\u4ee5\u5f80\u66f4\u52a0\u5bb9\u6613\u3002\u7d50\u5408\u9019\u9805\u65b0\u529f\u80fd\u8207 Pure Storage API\uff0c\u6211\u5011\u5c31\u80fd\u9806\u66a2\u5730\u8abf\u5ea6\u5feb\u7167\u4f5c\u696d\uff0c\u7121\u9700\u5916\u90e8\u5de5\u5177\u6216\u6307\u4ee4\u78bc\u3002<\/p>\n\n\n\n

\u5982\u679c\u60a8\u4e00\u76f4\u95dc\u6ce8\u6211\u7684\u201c\u4f7f\u7528 T-SQL \u5feb\u7167\u5099\u4efd\u201d\u7cfb\u5217<\/a>\uff0c\u60a8\u77e5\u9053\u9019\u9805\u529f\u80fd\u70ba\u5927\u578b\u8cc7\u6599\u5eab\u74b0\u5883\u5e36\u4f86\u5de8\u5927\u6548\u76ca\u3002\u4eca\u5929\uff0c\u6211\u5011\u5c07\u63a2\u8a0e\u5982\u4f55\u5229\u7528 SQL Server \u7684\u5916\u90e8 REST \u7aef\u9ede\u529f\u80fd\uff0c\u76f4\u63a5\u5728 T-SQL \u4e2d\u5be6\u4f5c\uff0c\u800c\u4e0d\u9700\u4f7f\u7528 PowerShell\u3002<\/p>\n\n\n\n

\u4e26\u5229\u7528 SQL Server \u547c\u53eb\u5916\u90e8 REST \u7aef\u9ede\u7684\u80fd\u529b\uff0c\u56e0\u6b64\u4e0d\u9700\u8981 PowerShell\u3002<\/p>\n\n\n\n

\u60a8\u53ef\u4ee5\u5728\u9019\u88e1<\/a>\u53d6\u5f97\u5b8c\u6574\u7684\u8173\u672c\u3002<\/strong><\/p>\n\n\n\n

\n\n\n\n

\u5728 SQL Server 2025 \u4e2d\u555f\u7528 REST \u7aef\u9ede<\/h2>\n\n\n\n

\u9996\u5148\uff0c\u6211\u5011\u4f86\u78ba\u5b9a\u53ef\u4ee5\u9023\u7dda\u5230\u5916\u90e8 REST \u7aef\u9ede\uff1a<\/p>\n\n\n\n

sp_configure 'external rest endpoint enabled', 1;\nRECONFIGURE WITH OVERRIDE;\n<\/code><\/pre>\n\n\n\n
\u9019\u555f\u7528\u4e86 SQL Server REST \u7aef\u9ede\u529f\u80fd\uff0c\u9019\u8b93\u6211\u5011\u7684 SQL Server \u53ef\u4ee5\u9032\u884c REST API \u5916\u64a5\u547c\u53eb\u3002\u9019\u5c0d\u65bc\u9023\u63a5\u5230 FlashArray \u7684 API \u4ee5\u89f8\u767c\u5feb\u7167\u81f3\u95dc\u91cd\u8981\u3002<\/p>\n\n\n\n
\u8acb\u6ce8\u610f\uff0c\u6240\u6709\u7aef\u9edesp_invoke_external_rest_endpoint<\/code>\u90fd\u5fc5\u9808\u4f7f\u7528 HTTPS \u642d\u914d TLS \u52a0\u5bc6\uff0c\u4e14\u6191\u8b49\u5fc5\u9808\u53d7\u8a17\u7ba1 SQL Server \u57f7\u884c\u500b\u9ad4\u7684\u57fa\u790e\u4f5c\u696d\u7cfb\u7d71\u6240\u4fe1\u4efb\u3002<\/p>\n\n\n\n
\u4f7f\u7528 FlashArray \u9a57\u8b49<\/h2>\n\n\n\n
\u63a5\u4e0b\u4f86\uff0c\u6211\u5011\u5c07\u4f7f\u7528 SQL Server 2025 \u7684\u65b0sp_invoke_external_rest_endpoint<\/code>\u5132\u5b58\u7a0b\u5e8f\uff0c\u8207 Pure Storage FlashArray \u5efa\u7acb\u5b89\u5168\u7684\u5de5\u4f5c\u968e\u6bb5\u3002\u6b64\u529f\u80fd\u4ee3\u8868 SQL Server \u529f\u80fd\u6709\u91cd\u5927\u9032\u6b65\uff0c\u8b93\u6211\u5011\u80fd\u5920\u76f4\u63a5\u5f9e T-SQL \u9032\u884c REST API \u547c\u53eb\uff0c\u800c\u7121\u9700\u5916\u90e8\u6307\u4ee4\u78bc\u3002<\/p>\n\n\n\n
\u70ba\u4e86\u9a57\u8b49 FlashArray\uff0c\u6211\u5011\u9996\u5148\u8981\u5411 FlashArray \u7684\u767b\u5165\u7aef\u9ede\u63d0\u4ea4\u5177\u6709\u8db3\u5920\u6b0a\u9650\u7684 API \u6b0a\u6756<\/a>\u3002\u6210\u529f\u9a57\u8b49\u5f8c\uff0cFlashArray \u6703\u50b3\u56de\u56de\u61c9\u6a19\u982d\u4e2d\u7684 anx-auth-token<\/code>\uff0c\u800c\u56de\u61c9\u6a19\u982d\u6703\u6210\u70ba\u672c\u5de5\u4f5c\u968e\u6bb5\u4e2d\u6240\u6709\u5f8c\u7e8c API \u4f5c\u696d\u7684\u5de5\u4f5c\u968e\u6bb5\u8a8d\u8b49\u3002\u9019\u7a2e\u57fa\u65bc\u6b0a\u6756\u7684\u9a57\u8b49\u6a21\u5f0f\u70ba API \u4e92\u52d5\u63d0\u4f9b\u4e86\u5b89\u5168\u3001\u9650\u6642\u6a5f\u5236\uff0c\u540c\u6642\u4fdd\u6301\u660e\u78ba\u7684\u64cd\u4f5c\u7a3d\u6838\u8ecc\u8de1\u3002<\/p>\n\n\n\n
\u5728\u4e0b\u9762\u7684\u7a0b\u5f0f\u78bc\u4e2d\uff0c\u6211\u5011\u6703\u57f7\u884c\u6b64\u9a57\u8b49\u8acb\u6c42\uff0c\u7136\u5f8c\u5f9e JSON \u56de\u61c9\u4e2d\u64f7\u53d6x-auth-token<\/code>\uff0c\u4ee5\u5efa\u7acb\u6388\u6b0a\u6a19\u982d\uff0c\u4f9b\u5f8c\u7e8c REST API \u547c\u53eb\u4f7f\u7528\u3002<\/p>\n\n\n\n
DECLARE @ret INT, @response NVARCHAR(MAX), @AuthToken NVARCHAR(100), @MyHeaders NVARCHAR(100);\n\nEXEC @ret = sp_invoke_external_rest_endpoint\n @url = N'https:\/\/flasharray1.purestorage.com\/api\/2.36\/login',\n @headers = N'{\"api-token\":\"PASTE_YOUR_TOKEN_HERE\"}',\n @response = @response OUTPUT;\n\nPRINT 'Login Return Code: ' + CAST(@ret AS NVARCHAR(10))\nPRINT 'Login Response: ' + @response\n<\/code><\/pre>\n\n\n\n
\u932f\u8aa4\u8655\u7406\u8207\u91d1\u9470\u64f7\u53d6<\/h2>\n\n\n\n
\u63a5\u4e0b\u4f86\uff0c\u6211\u5011\u5c07\u9a57\u8b49\u767b\u5165\u6210\u529f\u8207\u5426\uff0c\u4e26\u64f7\u53d6\u9a57\u8b49\u6b0a\u6756\u3002\u5982\u679c FlashArray \u7684\u9000\u8ca8\u4ee3\u78bc\u4e0d\u662f 0\uff0c\u6211\u5011\u6703\u5217\u5370\u932f\u8aa4\u8a0a\u606f\u4e26\u9000\u51fa\u3002\u5047\u8a2d\u6210\u529f\uff0c\u6211\u5011\u5c07\u5f9e\u767b\u5165\u56de\u61c9\u4e2d\u8b80\u53d6\u9a57\u8b49\u6b21\u6578<\/code>\u3002\u8acb\u6ce8\u610f\uff0c\u91d1\u9470\u5fc5\u9808\u5305\u542b\u96d9\u5f15\u865f\"x-auth-token\"<\/code>\uff0c\u4ee5\u78ba\u4fddJSON_VALUE<\/code>\u6b63\u78ba\u5256\u6790\u3002\u64f7\u53d6\u5f8c\uff0c\u6211\u5011\u6703\u4f7f\u7528\u6b0a\u6756\u4f86\u5efa\u7acb\u6388\u6b0a\u6a19\u982d\uff0c\u4ee5\u4fbf\u5f8c\u7e8c\u5c0d\u9663\u5217\u9032\u884c REST API \u8abf\u7528\u3002<\/p>\n\n\n\n
if ( @ret <> 0 )\n    BEGIN\n        PRINT 'Error in REST call, unable to login to the array.'\n        RETURN\n    END\n\nSET @AuthToken = JSON_VALUE(@response, '$.response.headers.\"x-auth-token\"'); \nSET @MyHeaders = N'{\"x-auth-token\":\"' + @AuthToken + '\", \"Content-Type\":\"application\/json\"}'\n\nPRINT 'Headers: ' + @MyHeaders\n<\/code><\/pre>\n\n\n\n
\u51cd\u7d50\u5feb\u7167\u8cc7\u6599\u5eab<\/h2>\n\n\n\n
\u95dc\u9375\u6b65\u9a5f\u662f\uff1a\u66ab\u505c\u8cc7\u6599\u5eab\u5beb\u5165 I\/O \u4ee5\u6e96\u5099\u5feb\u7167\u3002\u6b64\u547d\u4ee4\u4f7f\u7528 SQL Server 2022 \u7684 T-SQL \u5feb\u7167\u5099\u4efd\u529f\u80fd\u51cd\u7d50\u8cc7\u6599\u5eab\u4e0a\u7684\u5beb\u5165 I\/O \u4f5c\u696d\u3002\u8cc7\u6599\u5eab\u4ecd\u7136\u53ef\u4ee5\u8b80\u53d6\uff0c\u4f46\u5beb\u5165\u4f5c\u696d\u6703\u66ab\u505c\uff0c\u76f4\u5230\u6211\u5011\u5b8c\u6210\u5feb\u7167\u6d41\u7a0b\u70ba\u6b62\u3002\u5982\u6b64\u53ef\u78ba\u4fdd\u6211\u5011\u80fd\u53d6\u5f97\u61c9\u7528\u7a0b\u5f0f\u4e00\u81f4\u7684\u5feb\u7167\u3002<\/p>\n\n\n\n
ALTER DATABASE [TestDB1] SET SUSPEND_FOR_SNAPSHOT_BACKUP = ON\n<\/code><\/pre>\n\n\n\n
\u4f7f\u7528\u5132\u5b58\u5feb\u7167<\/h2>\n\n\n\n
\u5c07\u5beb\u5165 I\/O \u51cd\u7d50\u5728\u8cc7\u6599\u5eab\u4e2d\uff0c\u6211\u5011\u5df2\u6e96\u5099\u597d\u5728 FlashArray \u4e0a\u9032\u884c\u5feb\u7167\u3002\u4e0b\u4e00\u6b65\u662f\u547c\u53eb\u4fdd\u8b77\u7fa4\u7d44\u5feb\u7167<\/code>REST\u7aef\u9ede\uff0c\u555f\u52d5\u4fdd\u8b77\u7fa4\u7d44\u7684\u5feb\u7167\u5099\u4efd\u3002<\/p>\n\n\n\n
EXEC @ret = sp_invoke_external_rest_endpoint\n @url = N'https:\/\/flasharray1.purestorage.com\/api\/2.36\/protection-group-snapshots',\n @headers = @MyHeaders,\n @payload = N'{\"source_names\":\"aen-sql-25-a-pg\"}',    \n @response = @response OUTPUT;\n\nPRINT 'Snapshot Return Code: ' + CAST(@ret AS NVARCHAR(10))\nPRINT 'Snapshot Response: ' + @response\n<\/code><\/pre>\n\n\n\n
\u9019\u88e1\u6211\u5011\u7a31\u70ba FlashArray \u7684 REST API \u4fdd\u8b77\u7fa4\u7d44\u5feb\u7167<\/code>\uff0c\u4ee5\u5efa\u7acb\u540d\u70ba aen-sql-25-a-pg<\/code> \u7684\u4fdd\u8b77\u7fa4\u7d44\u5feb\u7167\u3002\u4fdd\u8b77\u7fa4\u7d44\u9700\u8981\u5305\u542b\u8cc7\u6599\u5eab\u6a94\u6848\u5132\u5b58\u7684\u6240\u6709\u78c1\u789f\u5340\u3002FlashArray \u5c07\u5efa\u7acb\u6b64\u4fdd\u8b77\u7fa4\u7d44\u4e2d\u6240\u6709\u78c1\u789f\u5340\u7684\u5373\u6642\u5feb\u7167\u3002<\/p>\n\n\n\n
\u64f7\u53d6\u5feb\u7167\u540d\u7a31\u4e26\u5efa\u7acb\u5099\u4efd<\/h2>\n\n\n\n
\u5728\u4e0b\u4e00\u500b\u6b65\u9a5f\u4e2d\uff0c\u6211\u5011\u4f7f\u7528 JSON_VALUE(@response,'$.result.items[0].name'\uff09<\/code> \u5f9e FlashArray \u7684 JSON \u56de\u61c9\u4e2d\u64f7\u53d6\u5feb\u7167\u540d\u7a31\u3002\u6b64\u540d\u7a31\u5c07\u5305\u542b\u5728\u5099\u4efd\u5a92\u9ad4\u8aaa\u660e\u4e2d\uff0c\u4f5c\u70ba\u50c5\u4e2d\u7e7c\u8cc7\u6599\u5099\u4efd\u7684\u4e00\u90e8\u5206\u3002\u5982\u679c FlashArray \u50b3\u56de\u6210\u529f\u4ee3\u78bc\uff08\u50b3\u56de\u4ee3\u78bc = 0\uff09\uff0c\u6211\u5011\u6703\u4f7f\u7528\u5099\u4efd\u8cc7\u6599\u5eab<\/code>\u6307\u4ee4\u548cMETADATA_ONLY<\/code>\u9078\u9805\u7e7c\u7e8c\u5099\u4efd\u3002\u5982\u6b64\u53ef\u5efa\u7acb\u8f15\u91cf\u5099\u4efd\u6a94\u6848\uff0c\u50c5\u5305\u542b\u8cc7\u6599\u5eab\u4e2d\u7e7c\u8cc7\u6599\uff0c\u4e26\u53c3\u8003MEDIADESCRIPTION<\/code> \u4e2d\u7684 FlashArray \u5feb\u7167\u3002\u5c07\u5feb\u7167\u540d\u7a31\u5132\u5b58\u5728 MEDIADESCRIPTION \u4e2d\uff0c\u5728\u57f7\u884c\u9084\u539f\u4f5c\u696d\u6642\uff0c\u80fd\u66f4\u8f15\u9b06\u5730\u8b58\u5225\u4e26\u5b9a\u4f4d\u5c0d\u61c9\u7684 FlashArray \u5feb\u7167\u3002<\/p>\n\n\n\n
\u5982\u679c\u5feb\u7167\u64cd\u4f5c\u5931\u6557\uff0c\u6211\u5011\u6703\u8a18\u9304\u932f\u8aa4\u8a0a\u606f\uff0c\u4e26\u7acb\u5373\u89e3\u9664\u8cc7\u6599\u5eab\u7684\u66ab\u505c\uff0c\u4ee5\u6062\u5fa9\u6b63\u5e38\u5beb\u5165 I\/O\u3002<\/p>\n\n\n\n
DECLARE @SnapshotName NVARCHAR(100)\nSET @SnapshotName = JSON_VALUE(@response, '$.result.items[0].name')\n\nif ( @ret = 0 ) \n    BEGIN\n        BACKUP DATABASE [TestDB1] TO DISK='SnapshotBack.bkm' WITH METADATA_ONLY, MEDIADESCRIPTION=@SnapshotName\n        PRINT 'Snapshot backup successful. Snapshot Name: ' + @SnapshotName\n    END\nELSE \n    BEGIN\n        ALTER DATABASE [TestDB1] SET SUSPEND_FOR_SNAPSHOT_BACKUP = OFF\n        PRINT 'Error in REST call, snapshot backup failed. Database unsuspended.'\n    END\n<\/code><\/pre>\n\n\n\n
\u6aa2\u67e5 SQL Server \u932f\u8aa4\u65e5\u8a8c<\/h2>\n\n\n\n
\u82e5\u8981\u9a57\u8b49\u5099\u4efd\u4f5c\u696d\uff0c\u6211\u5011\u6703\u6aa2\u67e5 SQL Server \u932f\u8aa4\u8a18\u9304\u3002<\/p>\n\n\n\n
SQL Server \u932f\u8aa4\u65e5\u8a8c\u78ba\u8a8d TestDB1 \u8cc7\u6599\u5eab\u6210\u529f\u5099\u4efd\u50c5\u4e2d\u7e7c\u8cc7\u6599\u7684\u5feb\u7167\u3002\u65e5\u8a8c\u986f\u793a\u8cc7\u6599\u5eab\u5df2\u66ab\u505c\u3001\u5beb\u5165 I\/O \u5df2\u51cd\u7d50\uff0c\u4e14\u5feb\u7167\u662f\u5728\u5b89\u5168\u6062\u5fa9 I\/O \u4e4b\u524d\u62cd\u651d\u3002\u7531\u65bc\u9019\u662f\u7d14\u4e2d\u7e7c\u8cc7\u6599\u7684\u5099\u4efd\uff0c\u56e0\u6b64\u4e0d\u6703\u8655\u7406\u4efb\u4f55\u8cc7\u6599\u9801\u9762\uff1b\u50c5\u64f7\u53d6\u4e2d\u7e7c\u8cc7\u6599\u4e26\u5beb\u5165\u6307\u5b9a\u7684 .bkm<\/code>file\u3002\u5982\u6b64\u53ef\u78ba\u4fdd\u61c9\u7528\u7a0b\u5f0f\u4e00\u81f4\u6027\u7684\u5feb\u7167\uff0c\u4e26\u5c0d\u8cc7\u6599\u5eab\u53ef\u7528\u6027\u7522\u751f\u6700\u5c0f\u7684\u5f71\u97ff\u3002<\/p>\n\n\n\n
EXEC xp_readerrorlog 0, 1, NULL, NULL, NULL, NULL, N'desc'\n\n2025-05-09 12:03:25.120 Backup  BACKUP DATABASE successfully processed 0 pages in 0.004 seconds (0.000 MB\/sec).\n2025-05-09 12:03:25.090 Backup  Database backed up. Database: TestDB1, creation date(time): 2025\/04\/30(16:05:02), pages dumped: 394061770, first LSN: 80323:19757:39, last LSN: 80323:19774:1, number of dump devices: 1, device information: (FILE=12, TYPE=DISK: {'C:\\Program Files\\Microsoft SQL Server\\MSSQL17.MSSQLSERVER\\MSSQL\\Backup\\SnapshotBack.bkm'}). This is an informational message only. No user action is required.\n2025-05-09 12:03:25.080 spid86  Database 'TestDB1' originally suspended for snapshot backup in session 86 successfully resumed in session 86.\n2025-05-09 12:03:25.080 spid86  Database 'TestDB1' released suspend locks in session 86.\n2025-05-09 12:03:25.080 spid86  I\/O was resumed on database TestDB1. No user action is required.\n2025-05-09 12:03:25.080 spid86  I\/O is frozen on database TestDB1. No user action is required. However, if I\/O is not resumed promptly, you could cancel the backup.\n2025-05-09 12:03:22.110 spid86  Database 'TestDB1' successfully suspended for snapshot backup in session 86.\n2025-05-09 12:03:22.110 spid86  I\/O is frozen on database TestDB1. No user action is required. However, if I\/O is not resumed promptly, you could cancel the backup.\n2025-05-09 12:03:22.070 spid86  Database 'TestDB1' acquired suspend locks in session 86.\n2025-05-09 12:03:22.070 spid86  Setting database option suspend_for_snapshot_backup to ON for database 'TestDB1'.\n<\/code><\/pre>\n\n\n\n
\u4ee5\u4e0b\u662f\u6211\u5011\u4e0a\u8ff0\u4f7f\u7528\u7684\u5217\u5370\u5c0d\u5e33\u55ae\u8f38\u51fa\u3002\u5feb\u7167\u5099\u4efd\u6210\u529f\u5b8c\u6210\uff1a\u7cfb\u7d71\u901a\u904e FlashArray \u9a57\u8b49\uff0c\u66ab\u505c TestDB1 \u51cd\u7d50 I\/O\uff0c\u5efa\u7acb\u5feb\u7167\uff08aen-sql-25-a-pg.17\uff09<\/code>\uff0c\u6062\u5fa9 I\/O\uff0c\u4e26\u5b8c\u6210\u50c5\u4e2d\u7e7c\u8cc7\u6599\u7684\u5099\u4efd\uff0c\u6240\u6709\u5099\u4efd\u90fd\u900f\u904e SQL Server \u65e5\u8a8c\u548c API \u56de\u61c9\u9032\u884c\u78ba\u8a8d\u3002<\/p>\n\n\n\n
Login Return Code: 0\nLogin Response: {\"response\":{\"status\":{\"http\":{\"code\":200,\"description\":\"\"}},\"headers\":{\"Date\":\"Fri, 09 May 2025 12:03:22 GMT\",\"Content-Length\":\"37\",\"Content-Type\":\"application\\\/json\",\"Server\":\"nginx\",\"x-auth-token\":\"75b2b984-a238-44ce-adbd-ff19decab148\",\"strict-transport-security\":\"max-age=31536000; includeSubDomains;\",\"content-security-policy\":\"frame-ancestors 'none'\",\"x-frame-options\":\"DENY\",\"x-content-type-options\":\"nosniff\",\"x-xss-protection\":\"1; mode=block\",\"x-request-id\":\"bdc6bbff70105c00fdeac8b0a1af565c\"}},\"result\":{\"items\":[{\"username\":\"anocentino\"}]}}\n\nHeaders: {\"x-auth-token\":\"75b2b984-a238-44ce-adbd-ff19decab148\", \"Content-Type\":\"application\/json\"}\n\nDatabase 'TestDB1' acquired suspend locks in session 86.\nI\/O is frozen on database TestDB1. No user action is required. However, if I\/O is not resumed promptly, you could cancel the backup.\nDatabase 'TestDB1' successfully suspended for snapshot backup in session 86.\n\nSnapshot Return Code: 0\nSnapshot Response: {\"response\":{\"status\":{\"http\":{\"code\":200,\"description\":\"\"}},\"headers\":{\"Date\":\"Fri, 09 May 2025 12:03:22 GMT\",\"Content-Length\":\"340\",\"Content-Type\":\"application\\\/json\",\"Server\":\"nginx\",\"x-auth-token\":\"75b2b984-a238-44ce-adbd-ff19decab148\",\"strict-transport-security\":\"max-age=31536000; includeSubDomains;\",\"content-security-policy\":\"frame-ancestors 'none'\",\"x-frame-options\":\"DENY\",\"x-content-type-options\":\"nosniff\",\"x-xss-protection\":\"1; mode=block\",\"x-request-id\":\"e3089939224baca84d6ad69b485855de\"}},\"result\":{\"items\":[{\"name\":\"aen-sql-25-a-pg.17\",\"id\":\"32e86de3-a3ee-3ae0-f74c-4bf5a7f74744\",\"space\":null,\"source\":{\"name\":\"aen-sql-25-a-pg\",\"id\":\"b6660b61-a8de-ae1b-cb65-e3045d13b5ba\"},\"suffix\":\"17\",\"destroyed\":false,\"created\":1746792202183,\"pod\":{\"name\":null,\"id\":null},\"time_remaining\":null,\"eradication_config\":{\"manual_eradication\":\"enabled\"}}]}}\n\nI\/O was resumed on database TestDB1. No user action is required.\nDatabase 'TestDB1' released suspend locks in session 86.\nDatabase 'TestDB1' originally suspended for snapshot backup in session 86 successfully resumed in session 86.\nProcessed 0 pages for database 'TestDB1', file 'test_data_01' on file 12.\nProcessed 0 pages for database 'TestDB1', file 'test_data_02' on file 12.\nProcessed 0 pages for database 'TestDB1', file 'test_data_03' on file 12.\nProcessed 0 pages for database 'TestDB1', file 'test_data_04' on file 12.\nProcessed 0 pages for database 'TestDB1', file 'test_data_05' on file 12.\nProcessed 0 pages for database 'TestDB1', file 'test_data_06' on file 12.\nProcessed 0 pages for database 'TestDB1', file 'test_data_07' on file 12.\nProcessed 0 pages for database 'TestDB1', file 'test_data_08' on file 12.\nBACKUP DATABASE successfully processed 0 pages in 0.004 seconds (0.000 MB\/sec).\n\nSnapshot backup successful. Snapshot Name: aen-sql-25-a-pg.17\n<\/code><\/pre>\n\n\n\n
\u7e3d\u7d50<\/h2>\n\n\n\n
\u672c\u7bc4\u4f8b\u5f37\u8abf SQL Server 2025 \u7684\u65b0sp_invoke_external_rest_endpoint<\/code>\u7a0b\u5e8f\u5982\u4f55\u6539\u8b8a\u5099\u4efd\u81ea\u52d5\u5316\u3002\u5728\u6b64\u4e4b\u524d\uff0c\u8207\u5132\u5b58\u7cfb\u7d71\u6574\u5408\u9700\u8981 PowerShell \u6216\u5916\u90e8\u5de5\u5177\u3002\u73fe\u5728\uff0c\u6211\u5011\u53ef\u4ee5\u5f9e T-SQL \u539f\u751f\u9032\u884c REST API \u547c\u53eb\uff0c\u7c21\u5316\u5de5\u4f5c\u6d41\u7a0b\u4e26\u964d\u4f4e\u8907\u96dc\u6027\u3002<\/p>\n\n\n\n
\u4e3b\u8981\u512a\u9ede\uff1a<\/p>\n\n\n\n