{"id":79677,"date":"2026-03-02T19:32:27","date_gmt":"2026-03-02T11:32:27","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/79677.html"},"modified":"2026-03-02T19:32:27","modified_gmt":"2026-03-02T11:32:27","slug":"sql-server%e8%87%aa%e5%8a%a8%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd%e8%bf%98%e5%8e%9f%e5%88%b0%e5%8f%a6%e4%b8%80%e5%8f%b0%e6%9c%8d%e5%8a%a1%e5%99%a8","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/79677.html","title":{"rendered":"SQL Server\u81ea\u52a8\u5b9a\u65f6\u5907\u4efd\u8fd8\u539f\u5230\u53e6\u4e00\u53f0\u670d\u52a1\u5668"},"content":{"rendered":"

10.101.10.252 \u670d\u52a1\u5668\u662f\u751f\u4ea7\u6570\u636e\u5e93\u670d\u52a1\u5668，10.80.189.43 \u670d\u52a1\u5668\u662f\u5f00\u53d1\u6d4b\u8bd5\u670d\u52a1\u5668，\u60f3\u8981\u5c06 10.101.10.252 \u4e0a\u7684\u751f\u4ea7\u5e93\u6bcf\u5929\u65e9\u4e0a6\u70b9\u5907\u4efd\u8fd8\u539f\u5230 10.80.189.43 \u4e0a，\u64cd\u4f5c\u5982\u4e0b：<\/p>\n

\u9996\u5148\u5728 10.101.10.252 \u4e0a\u9762\u521b\u5efa\u4e00\u4e2a SQL Server \u4ee3\u7406\u4f5c\u4e1a，\u4ee5\u5b9a\u65f6\u5907\u4efd\u6570\u636e\u5e93，\u5982\u4e0b：<\/p>\n

USE<\/span> [<\/span>msdb]<\/span>
\nGO<\/p>\n

\/****** Object: Job [LGJL\u751f\u4ea7\u5e93\u65e5\u5e38\u5907\u4efd\u4f5c\u4e1a] Script Date: 2025\/10\/10 7:56:17 ******\/<\/span>
\nBEGIN<\/span> TRANSACTION<\/span>
\nDECLARE<\/span> @ReturnCode<\/span> INT<\/span>
\nSELECT<\/span> @ReturnCode<\/span> =<\/span> 0<\/span>
\n\/****** Object: JobCategory [[Uncategorized (Local)]] Script Date: 2025\/10\/10 7:56:17 ******\/<\/span>
\nIF<\/span> NOT<\/span> EXISTS<\/span> (<\/span>SELECT<\/span> name FROM<\/span> msdb.<\/span>dbo.<\/span>syscategories WHERE<\/span> name=<\/span>N'[Uncategorized (Local)]'<\/span> AND<\/span> category_class=<\/span>1<\/span>)<\/span>
\nBEGIN<\/span>
\nEXEC<\/span> @ReturnCode<\/span> =<\/span> msdb.<\/span>dbo.<\/span>sp_add_category @class<\/span>=<\/span>N'JOB'<\/span>,<\/span> @type<\/span>=<\/span>N'LOCAL'<\/span>,<\/span> @name<\/span>=<\/span>N'[Uncategorized (Local)]'<\/span>
\nIF<\/span> (<\/span>@@ERROR<\/span> <><\/span> 0<\/span> OR<\/span> @ReturnCode<\/span> <><\/span> 0<\/span>)<\/span> GOTO<\/span> QuitWithRollback<\/p>\n

END<\/span><\/p>\n

DECLARE<\/span> @jobId<\/span> BINARY<\/span>(<\/span>16<\/span>)<\/span>
\nEXEC<\/span> @ReturnCode<\/span> =<\/span> msdb.<\/span>dbo.<\/span>sp_add_job @job_name<\/span>=<\/span>N'LGJL\u751f\u4ea7\u5e93\u65e5\u5e38\u5907\u4efd\u4f5c\u4e1a'<\/span>,<\/span>
\n@enabled<\/span>=<\/span>1<\/span>,<\/span>
\n@notify_level_eventlog<\/span>=<\/span>2<\/span>,<\/span>
\n@notify_level_email<\/span>=<\/span>0<\/span>,<\/span>
\n@notify_level_netsend<\/span>=<\/span>0<\/span>,<\/span>
\n@notify_level_page<\/span>=<\/span>0<\/span>,<\/span>
\n@delete_level<\/span>=<\/span>0<\/span>,<\/span>
\n@description<\/span>=<\/span>N'\u4e3a\u5f00\u53d1\u6d4b\u8bd5\u73af\u5883\u51c6\u5907\u7684\u6570\u636e\u5e93\u5907\u4efd'<\/span>,<\/span>
\n@category_name<\/span>=<\/span>N'[Uncategorized (Local)]'<\/span>,<\/span>
\n@owner_login_name<\/span>=<\/span>N'D621F944\\\\Administrator'<\/span>,<\/span> @job_id<\/span> =<\/span> @jobId<\/span> OUTPUT
\nIF<\/span> (<\/span>@@ERROR<\/span> <><\/span> 0<\/span> OR<\/span> @ReturnCode<\/span> <><\/span> 0<\/span>)<\/span> GOTO<\/span> QuitWithRollback
\n\/****** Object: Step [\u521b\u5efaCOPY_ONLY\u5907\u4efd] Script Date: 2025\/10\/10 7:56:17 ******\/<\/span>
\nEXEC<\/span> @ReturnCode<\/span> =<\/span> msdb.<\/span>dbo.<\/span>sp_add_jobstep @job_id<\/span>=<\/span>@jobId<\/span>,<\/span> @step_name<\/span>=<\/span>N'\u521b\u5efaCOPY_ONLY\u5907\u4efd'<\/span>,<\/span>
\n@step_id<\/span>=<\/span>1<\/span>,<\/span>
\n@cmdexec_success_code<\/span>=<\/span>0<\/span>,<\/span>
\n@on_success_action<\/span>=<\/span>1<\/span>,<\/span>
\n@on_success_step_id<\/span>=<\/span>0<\/span>,<\/span>
\n@on_fail_action<\/span>=<\/span>2<\/span>,<\/span>
\n@on_fail_step_id<\/span>=<\/span>0<\/span>,<\/span>
\n@retry_attempts<\/span>=<\/span>0<\/span>,<\/span>
\n@retry_interval<\/span>=<\/span>0<\/span>,<\/span>
\n@os_run_priority<\/span>=<\/span>0<\/span>,<\/span> @subsystem<\/span>=<\/span>N'TSQL'<\/span>,<\/span>
\n@command<\/span>=<\/span>N'DECLARE @DBName NVARCHAR(128) = ''LGJL'';
\nDECLARE @DBName1 NVARCHAR(128) = ''LGJLLOG'';
\nDECLARE @BackupPath NVARCHAR(512) = N''\\\\\\\\10.101.10.252\\\\Backup\\\\''<\/span>;<\/span>
\nDECLARE<\/span> @FileName<\/span> NVARCHAR(<\/span>512<\/span>)<\/span> =<\/span> @BackupPath<\/span> +<\/span> @DBName<\/span> +<\/span>
\n ''<\/span>_''<\/span> +<\/span> CONVERT<\/span>(<\/span>NVARCHAR(<\/span>8<\/span>)<\/span>,<\/span> GETDATE(<\/span>)<\/span>,<\/span> 112<\/span>)<\/span> +<\/span> ''<\/span>_''<\/span> +<\/span>
\n REPLACE<\/span>(<\/span>CONVERT<\/span>(<\/span>NVARCHAR(<\/span>8<\/span>)<\/span>,<\/span> GETDATE(<\/span>)<\/span>,<\/span> 108<\/span>)<\/span>,<\/span> ''<\/span>:''<\/span>,<\/span> ''''<\/span>)<\/span> +<\/span> ''<\/span>.<\/span>bak''<\/span>;<\/span>
\nDECLARE<\/span> @FileName1<\/span> NVARCHAR(<\/span>512<\/span>)<\/span> =<\/span> @BackupPath<\/span> +<\/span> @DBName1<\/span> +<\/span>
\n ''<\/span>_''<\/span> +<\/span> CONVERT<\/span>(<\/span>NVARCHAR(<\/span>8<\/span>)<\/span>,<\/span> GETDATE(<\/span>)<\/span>,<\/span> 112<\/span>)<\/span> +<\/span> ''<\/span>_''<\/span> +<\/span>
\n REPLACE<\/span>(<\/span>CONVERT<\/span>(<\/span>NVARCHAR(<\/span>8<\/span>)<\/span>,<\/span> GETDATE(<\/span>)<\/span>,<\/span> 108<\/span>)<\/span>,<\/span> ''<\/span>:''<\/span>,<\/span> ''''<\/span>)<\/span> +<\/span> ''<\/span>.<\/span>bak''<\/span>;<\/span>
\nSELECT<\/span> @DBName<\/span>;<\/span><\/p>\n

— \u4f7f\u7528COPY_ONLY\u9009\u9879\u907f\u514d\u5e72\u6270\u751f\u4ea7\u73af\u5883\u7684\u5e38\u89c4\u5907\u4efd\u7b56\u7565<\/span>
\nBACKUP<\/span> DATABASE<\/span> @DBName<\/span>
\nTO<\/span> DISK<\/span> =<\/span> @FileName<\/span>
\nWITH<\/span> COPY_ONLY,<\/span> COMPRESSION,<\/span> STATS =<\/span> 10<\/span>,<\/span> CHECKSUM;<\/span>
\nBACKUP<\/span> DATABASE<\/span> @DBName1<\/span>
\nTO<\/span> DISK<\/span> =<\/span> @FileName1<\/span>
\nWITH<\/span> COPY_ONLY,<\/span> COMPRESSION,<\/span> STATS =<\/span> 10<\/span>,<\/span> CHECKSUM;<\/span>
\n',
\n@database_name=N'<\/span>master',
\n@flags=0
\nIF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
\nEXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1
\nIF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
\nEXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'<\/span>\u6bcf\u65e5\u65e9\u4e0a6<\/span>\u70b9\u5907\u4efd',
\n@enabled=1,
\n@freq_type=4,
\n@freq_interval=1,
\n@freq_subday_type=1,
\n@freq_subday_interval=0,
\n@freq_relative_interval=0,
\n@freq_recurrence_factor=0,
\n@active_start_date=20250516,
\n@active_end_date=99991231,
\n@active_start_time=60000,
\n@active_end_time=235959,
\n@schedule_uid=N'<\/span>a0036edb–<\/span>ab73–<\/span>4721<\/span>–<\/span>8888<\/span>–<\/span>638856033112<\/span>'
\nIF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
\nEXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'<\/span>(<\/span>local<\/span>)<\/span>'
\nIF<\/span> (<\/span>@@ERROR<\/span> <><\/span> 0<\/span> OR<\/span> @ReturnCode<\/span> <><\/span> 0<\/span>)<\/span> GOTO<\/span> QuitWithRollback
\nCOMMIT<\/span> TRANSACTION<\/span>
\nGOTO<\/span> EndSave
\nQuitWithRollback:
\n IF<\/span> (<\/span>@@TRANCOUNT<\/span> ><\/span> 0<\/span>)<\/span> ROLLBACK<\/span> TRANSACTION<\/span>
\nEndSave:<\/p>\n

GO<\/p>\n

\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

— LGJL_20251010_060000.bak<\/span>
\n— LGJLLOG_20251010_060000.bak<\/span>
\nDECLARE<\/span> @DBName<\/span> NVARCHAR(<\/span>128<\/span>)<\/span> =<\/span> 'LGJL'<\/span>;<\/span>
\nDECLARE<\/span> @DBName1<\/span> NVARCHAR(<\/span>128<\/span>)<\/span> =<\/span> 'LGJLLOG'<\/span>;<\/span>
\nDECLARE<\/span> @BackupPath<\/span> NVARCHAR(<\/span>512<\/span>)<\/span> =<\/span> N'\\\\\\\\10.101.10.252\\\\Backup\\\\';
\nDECLARE @FileName NVARCHAR(512) = @BackupPath + @DBName +
\n '<\/span>_' + CONVERT(NVARCHAR(8), GETDATE(), 112) + '<\/span>_' +
\n REPLACE(CONVERT(NVARCHAR(8), GETDATE(), 108), '<\/span>:', '') + '<\/span>.<\/span>bak';
\nDECLARE @FileName1 NVARCHAR(512) = @BackupPath + @DBName1 +
\n '<\/span>_' + CONVERT(NVARCHAR(8), GETDATE(), 112) + '<\/span>_' +
\n REPLACE(CONVERT(NVARCHAR(8), GETDATE(), 108), '<\/span>:', '') + '<\/span>.<\/span>bak';<\/span>
\nSELECT<\/span> @DBName<\/span>;<\/span><\/p>\n

— \u4f7f\u7528COPY_ONLY\u9009\u9879\u907f\u514d\u5e72\u6270\u751f\u4ea7\u73af\u5883\u7684\u5e38\u89c4\u5907\u4efd\u7b56\u7565<\/span>
\nBACKUP<\/span> DATABASE<\/span> @DBName<\/span>
\nTO<\/span> DISK<\/span> =<\/span> @FileName<\/span>
\nWITH<\/span> COPY_ONLY,<\/span> COMPRESSION,<\/span> STATS =<\/span> 10<\/span>,<\/span> CHECKSUM;<\/span>
\nBACKUP<\/span> DATABASE<\/span> @DBName1<\/span>
\nTO<\/span> DISK<\/span> =<\/span> @FileName1<\/span>
\nWITH<\/span> COPY_ONLY,<\/span> COMPRESSION,<\/span> STATS =<\/span> 10<\/span>,<\/span> CHECKSUM;<\/span><\/p>\n

\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

\u5c06 10.101.10.252 \u4e0a\u521b\u5efa\u4e00\u4e2a\u5171\u4eab\u6587\u4ef6\u5939，\u4ee5\u4fbf 10.80.189.43 \u62f7\u8d1d\u5907\u4efd\u7684\u6570\u636e\u5e93\u6587\u4ef6，\u5982\u4e0b：
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\n\u6dfb\u52a0 SQL_Worker \u5171\u4eab\u6743\u9650，\u5982\u4e0b：
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\n\u5728 10.80.189.43 \u4e0a\u9762\u6620\u5c04\u7f51\u7edc\u9a71\u52a8\u5668，\u5982\u4e0b：
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

\u5728 10.80.189.43 \u4e0a\u9762\u521b\u5efa\u4e00\u4e2a powershell \u811a\u672c，\u7528\u4ee5\u4ece\u5171\u4eab\u6587\u4ef6\u5939\u62f7\u8d1d\u5907\u4efd\u6587\u4ef6，\u5982\u4e0b：<\/p>\n

# net use F: \\\\\\\\10.101.10.252\\\\Backup \/user:10.101.10.252\\\\SQL_Worker "Anfeng@2025" \/persistent:no | Out-Null<\/span>
\n$SharePath<\/span> = "\\\\\\\\10.101.10.252\\\\Backup"<\/span>
\n$LocalPath<\/span> = "E:\\\\Program Files\\\\Microsoft SQL Server\\\\MSSQL16.MSSQLSERVER\\\\MSSQL\\\\Backup"<\/span>
\n$DBName<\/span> = "LGJL"<\/span>
\n$DBName1<\/span> = "LGJLLOG"<\/span><\/p>\n

$DateStr<\/span> = Get-Date<\/span> –<\/span>Format "yyyyMMdd"<\/span><\/p>\n

$FilePattern<\/span> = "${DBName}_${DateStr}_*.bak"<\/span>
\n$FilePattern1<\/span> = "${DBName1}_${DateStr}_*.bak"<\/span><\/p>\n

$File<\/span> = Get-ChildItem<\/span> –<\/span>Path $SharePath<\/span> –<\/span>Filter<\/span> $FilePattern<\/span> |<\/span> Select-Object<\/span> –<\/span>First 1
\n$File1<\/span> = Get-ChildItem<\/span> –<\/span>Path $SharePath<\/span> –<\/span>Filter<\/span> $FilePattern1<\/span> |<\/span> Select-Object<\/span> –<\/span>First 1<\/p>\n

if<\/span> (<\/span>$File<\/span>)<\/span> {<\/span>
\n $DestPath<\/span> = Join-Path<\/span> –<\/span>Path $LocalPath<\/span> –<\/span>ChildPath $File<\/span>.<\/span>Name<\/p>\n

try<\/span> {<\/span>
\n Copy-Item<\/span> –<\/span>Path $File<\/span>.<\/span>FullName –<\/span>Destination $DestPath<\/span> –<\/span>Force
\n Write-Output<\/span> "$(<\/span>Get-Date<\/span>)<\/span><\/span> – success copy file: $(<\/span>$File<\/span>.<\/span>Name)<\/span><\/span>"<\/span>
\n }<\/span>
\n catch<\/span> {<\/span>
\n Write-Error<\/span> "$(<\/span>Get-Date<\/span>)<\/span><\/span> – failed copy file: $_<\/span>"<\/span>
\n exit<\/span> 1
\n }<\/span>
\n}<\/span>
\nelse<\/span> {<\/span>
\n Write-Error<\/span> "$(<\/span>Get-Date<\/span>)<\/span><\/span> – can't find file: $FilePattern<\/span>"<\/span>
\n exit<\/span> 1
\n}<\/span><\/p>\n

if<\/span> (<\/span>$File1<\/span>)<\/span> {<\/span>
\n $DestPath1<\/span> = Join-Path<\/span> –<\/span>Path $LocalPath<\/span> –<\/span>ChildPath $File1<\/span>.<\/span>Name<\/p>\n

try<\/span> {<\/span>
\n Copy-Item<\/span> –<\/span>Path $File1<\/span>.<\/span>FullName –<\/span>Destination $DestPath1<\/span> –<\/span>Force
\n Write-Output<\/span> "$(<\/span>Get-Date<\/span>)<\/span><\/span> – success copy file: $(<\/span>$File1<\/span>.<\/span>Name)<\/span><\/span>"<\/span>
\n }<\/span>
\n catch<\/span> {<\/span>
\n Write-Error<\/span> "$(<\/span>Get-Date<\/span>)<\/span><\/span> – failed copy file: $_<\/span>"<\/span>
\n exit<\/span> 1
\n }<\/span>
\n}<\/span>
\nelse<\/span> {<\/span>
\n Write-Error<\/span> "$(<\/span>Get-Date<\/span>)<\/span><\/span> – can't find file: $FilePattern1<\/span>"<\/span>
\n exit<\/span> 1
\n}<\/span><\/p>\n

\u5728 10.80.189.43 \u4e0a\u9762\u7684\u4efb\u52a1\u8ba1\u5212\u7a0b\u5e8f\u4e2d\u521b\u5efa\u4efb\u52a1，\u5982\u4e0b：
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

\u5728 10.80.189.43 \u4e0a\u9762\u521b\u5efa\u4e00\u4e2a SQL Server \u4ee3\u7406\u4f5c\u4e1a，\u4ee5\u81ea\u52a8\u8fd8\u539f\u5907\u4efd\u7684\u6570\u636e\u5e93\u6587\u4ef6，\u5982\u4e0b：<\/p>\n

USE<\/span> [<\/span>msdb]<\/span>
\nGO<\/p>\n

\/****** Object: Job [LGJL\u6d4b\u8bd5\u73af\u5883\u81ea\u52a8\u8fd8\u539f\u4f5c\u4e1a] Script Date: 2025\/10\/10 8:19:31 ******\/<\/span>
\nBEGIN<\/span> TRANSACTION<\/span>
\nDECLARE<\/span> @ReturnCode<\/span> INT<\/span>
\nSELECT<\/span> @ReturnCode<\/span> =<\/span> 0<\/span>
\n\/****** Object: JobCategory [[Uncategorized (Local)]] Script Date: 2025\/10\/10 8:19:31 ******\/<\/span>
\nIF<\/span> NOT<\/span> EXISTS<\/span> (<\/span>SELECT<\/span> name FROM<\/span> msdb.<\/span>dbo.<\/span>syscategories WHERE<\/span> name=<\/span>N'[Uncategorized (Local)]'<\/span> AND<\/span> category_class=<\/span>1<\/span>)<\/span>
\nBEGIN<\/span>
\nEXEC<\/span> @ReturnCode<\/span> =<\/span> msdb.<\/span>dbo.<\/span>sp_add_category @class<\/span>=<\/span>N'JOB'<\/span>,<\/span> @type<\/span>=<\/span>N'LOCAL'<\/span>,<\/span> @name<\/span>=<\/span>N'[Uncategorized (Local)]'<\/span>
\nIF<\/span> (<\/span>@@ERROR<\/span> <><\/span> 0<\/span> OR<\/span> @ReturnCode<\/span> <><\/span> 0<\/span>)<\/span> GOTO<\/span> QuitWithRollback<\/p>\n

END<\/span><\/p>\n

DECLARE<\/span> @jobId<\/span> BINARY<\/span>(<\/span>16<\/span>)<\/span>
\nEXEC<\/span> @ReturnCode<\/span> =<\/span> msdb.<\/span>dbo.<\/span>sp_add_job @job_name<\/span>=<\/span>N'LGJL\u6d4b\u8bd5\u73af\u5883\u81ea\u52a8\u8fd8\u539f\u4f5c\u4e1a'<\/span>,<\/span>
\n@enabled<\/span>=<\/span>1<\/span>,<\/span>
\n@notify_level_eventlog<\/span>=<\/span>2<\/span>,<\/span>
\n@notify_level_email<\/span>=<\/span>0<\/span>,<\/span>
\n@notify_level_netsend<\/span>=<\/span>0<\/span>,<\/span>
\n@notify_level_page<\/span>=<\/span>0<\/span>,<\/span>
\n@delete_level<\/span>=<\/span>0<\/span>,<\/span>
\n@description<\/span>=<\/span>N'\u4ece\u751f\u4ea7\u5907\u4efd\u8fd8\u539f\u5230\u6d4b\u8bd5\u73af\u5883'<\/span>,<\/span>
\n@category_name<\/span>=<\/span>N'[Uncategorized (Local)]'<\/span>,<\/span>
\n@owner_login_name<\/span>=<\/span>N'sa'<\/span>,<\/span> @job_id<\/span> =<\/span> @jobId<\/span> OUTPUT
\nIF<\/span> (<\/span>@@ERROR<\/span> <><\/span> 0<\/span> OR<\/span> @ReturnCode<\/span> <><\/span> 0<\/span>)<\/span> GOTO<\/span> QuitWithRollback
\n\/****** Object: Step [\u8fd8\u539f\u751f\u4ea7\u6570\u636e\u5e93] Script Date: 2025\/10\/10 8:19:31 ******\/<\/span>
\nEXEC<\/span> @ReturnCode<\/span> =<\/span> msdb.<\/span>dbo.<\/span>sp_add_jobstep @job_id<\/span>=<\/span>@jobId<\/span>,<\/span> @step_name<\/span>=<\/span>N'\u8fd8\u539f\u751f\u4ea7\u6570\u636e\u5e93'<\/span>,<\/span>
\n@step_id<\/span>=<\/span>1<\/span>,<\/span>
\n@cmdexec_success_code<\/span>=<\/span>0<\/span>,<\/span>
\n@on_success_action<\/span>=<\/span>3<\/span>,<\/span>
\n@on_success_step_id<\/span>=<\/span>0<\/span>,<\/span>
\n@on_fail_action<\/span>=<\/span>3<\/span>,<\/span>
\n@on_fail_step_id<\/span>=<\/span>0<\/span>,<\/span>
\n@retry_attempts<\/span>=<\/span>0<\/span>,<\/span>
\n@retry_interval<\/span>=<\/span>0<\/span>,<\/span>
\n@os_run_priority<\/span>=<\/span>0<\/span>,<\/span> @subsystem<\/span>=<\/span>N'TSQL'<\/span>,<\/span>
\n@command<\/span>=<\/span>N'
\nDECLARE @DBName NVARCHAR(128) = ''LGJL'';
\nDECLARE @TestDBName NVARCHAR(128) = ''LGJL''; — \u6d4b\u8bd5\u73af\u5883\u4f7f\u7528\u4e0d\u540c\u540d\u79f0
\nDECLARE @BackupPath NVARCHAR(512) = N''E:\\\\Program Files\\\\Microsoft SQL Server\\\\MSSQL16.MSSQLSERVER\\\\MSSQL\\\\Backup\\\\''<\/span>;<\/span>
\nDECLARE<\/span> @FileName<\/span> NVARCHAR(<\/span>512<\/span>)<\/span>;<\/span><\/p>\n

— \u67e5\u627e\u6700\u65b0\u7684\u5907\u4efd\u6587\u4ef6（\u6309\u65e5\u671f\u6392\u5e8f）<\/span>
\nSELECT<\/span> TOP<\/span> 1<\/span> @FileName<\/span> =<\/span> @BackupPath<\/span> +<\/span> ''<\/span>LGJL''<\/span> +<\/span> ''<\/span>_''<\/span> +<\/span> CONVERT<\/span>(<\/span>VARCHAR<\/span>(<\/span>8<\/span>)<\/span>,<\/span> GETDATE(<\/span>)<\/span>,<\/span> 112<\/span>)<\/span> +<\/span> ''<\/span>_''<\/span> +<\/span> ''<\/span>060000.<\/span>bak''<\/span> –physical_device_name <\/span>
\nFROM<\/span> (<\/span>
\n SELECT<\/span> top<\/span> 1<\/span>
\nbs.<\/span>backup_set_id,<\/span>
\nbs.<\/span>database_name,<\/span>
\nbs.<\/span>backup_start_date,<\/span>
\nbs.<\/span>backup_finish_date,<\/span>
\nbs.<\/span>type<\/span> AS<\/span> backup_type,<\/span>
\nCASE<\/span> bs.<\/span>type<\/span>
\nWHEN<\/span> ''<\/span>D''<\/span> THEN<\/span> ''<\/span>\u5b8c\u6574\u5907\u4efd''<\/span>
\nWHEN<\/span> ''<\/span>I''<\/span> THEN<\/span> ''<\/span>\u5dee\u5f02\u5907\u4efd''<\/span>
\nWHEN<\/span> ''<\/span>L''<\/span> THEN<\/span> ''<\/span>\u65e5\u5fd7\u5907\u4efd''<\/span>
\nEND<\/span> AS<\/span> backup_type_desc,<\/span>
\nbs.<\/span>backup_size \/<\/span> 1024<\/span> \/<\/span> 1024<\/span> AS<\/span> backup_size_MB,<\/span>
\nbmf.<\/span>physical_device_name
\nFROM<\/span>
\n[<\/span>10.101<\/span>.10<\/span>.252<\/span>]<\/span>.<\/span>[<\/span>msdb]<\/span>.<\/span>[<\/span>dbo]<\/span>.<\/span>[<\/span>backupset]<\/span> bs
\nINNER<\/span> JOIN<\/span>
\n[<\/span>10.101<\/span>.10<\/span>.252<\/span>]<\/span>.<\/span>[<\/span>msdb]<\/span>.<\/span>[<\/span>dbo]<\/span>.<\/span>[<\/span>backupmediafamily]<\/span> bmf ON<\/span> bs.<\/span>media_set_id =<\/span> bmf.<\/span>media_set_id
\nWHERE<\/span> bs.<\/span>database_name LIKE<\/span> ''<\/span>%<\/span>''<\/span> +<\/span> @DBName<\/span> +<\/span> ''<\/span>%<\/span>''<\/span>
\nORDER<\/span> BY<\/span>
\nbs.<\/span>backup_start_date DESC<\/span>
\n)<\/span> AS<\/span> BackupFiles
\nORDER<\/span> BY<\/span> database_name DESC<\/span>;<\/span><\/p>\n

— \u786e\u4fdd\u627e\u5230\u4e86\u5907\u4efd\u6587\u4ef6<\/span>
\nIF<\/span> @FileName<\/span> IS<\/span> NULL<\/span>
\nBEGIN<\/span>
\n RAISERROR<\/span>(<\/span>''<\/span>\u672a\u627e\u5230\u6709\u6548\u7684\u5907\u4efd\u6587\u4ef6''<\/span>,<\/span> 16<\/span>,<\/span> 1<\/span>)<\/span>;<\/span>
\n RETURN<\/span>;<\/span>
\nEND<\/span><\/p>\n

PRINT<\/span> ''<\/span>\u6b63\u5728\u4ece\u6587\u4ef6: ''<\/span> +<\/span> @FileName<\/span> +<\/span> ''<\/span> \u8fd8\u539f\u6570\u636e\u5e93.<\/span>.<\/span>.<\/span>''<\/span>;<\/span><\/p>\n

— \u68c0\u67e5\u6d4b\u8bd5\u5e93\u662f\u5426\u5b58\u5728，\u5b58\u5728\u5219\u7f6e\u4e3a\u5355\u7528\u6237\u6a21\u5f0f<\/span>
\nIF<\/span> DB_ID(<\/span>@TestDBName<\/span>)<\/span> IS<\/span> NOT<\/span> NULL<\/span>
\nBEGIN<\/span>
\n EXEC<\/span>(<\/span>''<\/span>ALTER<\/span> DATABASE<\/span> ''<\/span> +<\/span> @TestDBName<\/span> +<\/span> ''<\/span> SET<\/span> SINGLE_USER WITH<\/span> ROLLBACK<\/span> IMMEDIATE''<\/span>)<\/span>;<\/span><\/p>\n

— \u4f7f\u7528REPLACE\u9009\u9879\u8986\u76d6\u73b0\u6709\u6570\u636e\u5e93<\/span>
\n RESTORE<\/span> DATABASE<\/span> @TestDBName<\/span>
\n FROM<\/span> DISK<\/span> =<\/span> @FileName<\/span>
\n WITH<\/span> REPLACE<\/span>,<\/span>
\n MOVE ''<\/span>LGJL_Data''<\/span> TO<\/span> ''<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\DATA<\/span>\\\\LGJL.<\/span>mdf''<\/span>,<\/span>
\n MOVE ''<\/span>LGJL_Log''<\/span> TO<\/span> ''<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\DATA<\/span>\\\\LGJL.<\/span>ldf''<\/span>,<\/span>
\n STATS =<\/span> 10<\/span>,<\/span> RECOVERY;<\/span><\/p>\n

EXEC<\/span>(<\/span>''<\/span>ALTER<\/span> DATABASE<\/span> ''<\/span> +<\/span> @TestDBName<\/span> +<\/span> ''<\/span> SET<\/span> MULTI_USER''<\/span>)<\/span>;<\/span>
\nEND<\/span>
\nELSE<\/span>
\nBEGIN<\/span>
\n — \u6570\u636e\u5e93\u4e0d\u5b58\u5728\u7684\u60c5\u51b5<\/span>
\n RESTORE<\/span> DATABASE<\/span> @TestDBName<\/span>
\n FROM<\/span> DISK<\/span> =<\/span> @FileName<\/span>
\n WITH<\/span>
\n MOVE ''<\/span>LGJL_Data''<\/span> TO<\/span> ''<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\DATA<\/span>\\\\LGJL.<\/span>mdf''<\/span>,<\/span>
\n MOVE ''<\/span>LGJL_Log''<\/span> TO<\/span> ''<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\DATA<\/span>\\\\LGJL.<\/span>ldf''<\/span>,<\/span>
\n STATS =<\/span> 10<\/span>,<\/span> RECOVERY;<\/span>
\nEND<\/span><\/p>\n

PRINT<\/span> ''<\/span>\u6570\u636e\u5e93\u8fd8\u539f\u5b8c\u6210''<\/span>;<\/span><\/p>\n

— \u67e5\u8be2\u5907\u4efd\u6587\u4ef6\u903b\u8f91\u540d<\/span>
\n\/*
\nRESTORE FILELISTONLY
\nFROM DISK = ''E:\\\\Program Files\\\\Microsoft SQL Server\\\\MSSQL16.MSSQLSERVER\\\\MSSQL\\\\Backup\\\\LGJL_20250518_060000.bak''
\n*\/<\/span><\/p>\n

— <\/span>
\n–IF DB_ID(''LGJL'') IS NOT NULL <\/span>
\n–BEGIN <\/span>
\n–PRINT ''hello''<\/span>
\n–END ', <\/span>
\n@database_name<\/span>=<\/span>N'master'<\/span>,<\/span>
\n@flags<\/span>=<\/span>0<\/span>
\nIF<\/span> (<\/span>@@ERROR<\/span> <><\/span> 0<\/span> OR<\/span> @ReturnCode<\/span> <><\/span> 0<\/span>)<\/span> GOTO<\/span> QuitWithRollback
\n\/****** Object: Step [\u8fd8\u539f\u751f\u4ea7\u6570\u636e\u5e93LGJLLOG] Script Date: 2025\/10\/10 8:19:31 ******\/<\/span>
\nEXEC<\/span> @ReturnCode<\/span> =<\/span> msdb.<\/span>dbo.<\/span>sp_add_jobstep @job_id<\/span>=<\/span>@jobId<\/span>,<\/span> @step_name<\/span>=<\/span>N'\u8fd8\u539f\u751f\u4ea7\u6570\u636e\u5e93LGJLLOG'<\/span>,<\/span>
\n@step_id<\/span>=<\/span>2<\/span>,<\/span>
\n@cmdexec_success_code<\/span>=<\/span>0<\/span>,<\/span>
\n@on_success_action<\/span>=<\/span>1<\/span>,<\/span>
\n@on_success_step_id<\/span>=<\/span>0<\/span>,<\/span>
\n@on_fail_action<\/span>=<\/span>2<\/span>,<\/span>
\n@on_fail_step_id<\/span>=<\/span>0<\/span>,<\/span>
\n@retry_attempts<\/span>=<\/span>0<\/span>,<\/span>
\n@retry_interval<\/span>=<\/span>0<\/span>,<\/span>
\n@os_run_priority<\/span>=<\/span>0<\/span>,<\/span> @subsystem<\/span>=<\/span>N'TSQL'<\/span>,<\/span>
\n@command<\/span>=<\/span>N'
\nDECLARE @DBName NVARCHAR(128) = ''LGJLLOG'';
\nDECLARE @TestDBName NVARCHAR(128) = ''LGJLLOG''; — \u6d4b\u8bd5\u73af\u5883\u4f7f\u7528\u4e0d\u540c\u540d\u79f0
\nDECLARE @BackupPath NVARCHAR(512) = N''E:\\\\Program Files\\\\Microsoft SQL Server\\\\MSSQL16.MSSQLSERVER\\\\MSSQL\\\\Backup\\\\''<\/span>;<\/span>
\nDECLARE<\/span> @FileName<\/span> NVARCHAR(<\/span>512<\/span>)<\/span>;<\/span><\/p>\n

— \u67e5\u627e\u6700\u65b0\u7684\u5907\u4efd\u6587\u4ef6（\u6309\u65e5\u671f\u6392\u5e8f）<\/span>
\nSELECT<\/span> TOP<\/span> 1<\/span> @FileName<\/span> =<\/span> @BackupPath<\/span> +<\/span> ''<\/span>LGJLLOG''<\/span> +<\/span> ''<\/span>_''<\/span> +<\/span> CONVERT<\/span>(<\/span>VARCHAR<\/span>(<\/span>8<\/span>)<\/span>,<\/span> GETDATE(<\/span>)<\/span>,<\/span> 112<\/span>)<\/span> +<\/span> ''<\/span>_''<\/span> +<\/span> ''<\/span>060000.<\/span>bak''<\/span> –physical_device_name <\/span>
\nFROM<\/span> (<\/span>
\n SELECT<\/span> top<\/span> 1<\/span>
\nbs.<\/span>backup_set_id,<\/span>
\nbs.<\/span>database_name,<\/span>
\nbs.<\/span>backup_start_date,<\/span>
\nbs.<\/span>backup_finish_date,<\/span>
\nbs.<\/span>type<\/span> AS<\/span> backup_type,<\/span>
\nCASE<\/span> bs.<\/span>type<\/span>
\nWHEN<\/span> ''<\/span>D''<\/span> THEN<\/span> ''<\/span>\u5b8c\u6574\u5907\u4efd''<\/span>
\nWHEN<\/span> ''<\/span>I''<\/span> THEN<\/span> ''<\/span>\u5dee\u5f02\u5907\u4efd''<\/span>
\nWHEN<\/span> ''<\/span>L''<\/span> THEN<\/span> ''<\/span>\u65e5\u5fd7\u5907\u4efd''<\/span>
\nEND<\/span> AS<\/span> backup_type_desc,<\/span>
\nbs.<\/span>backup_size \/<\/span> 1024<\/span> \/<\/span> 1024<\/span> AS<\/span> backup_size_MB,<\/span>
\nbmf.<\/span>physical_device_name
\nFROM<\/span>
\n[<\/span>10.101<\/span>.10<\/span>.252<\/span>]<\/span>.<\/span>[<\/span>msdb]<\/span>.<\/span>[<\/span>dbo]<\/span>.<\/span>[<\/span>backupset]<\/span> bs
\nINNER<\/span> JOIN<\/span>
\n[<\/span>10.101<\/span>.10<\/span>.252<\/span>]<\/span>.<\/span>[<\/span>msdb]<\/span>.<\/span>[<\/span>dbo]<\/span>.<\/span>[<\/span>backupmediafamily]<\/span> bmf ON<\/span> bs.<\/span>media_set_id =<\/span> bmf.<\/span>media_set_id
\nWHERE<\/span> bs.<\/span>database_name LIKE<\/span> ''<\/span>%<\/span>''<\/span> +<\/span> @DBName<\/span> +<\/span> ''<\/span>%<\/span>''<\/span>
\nORDER<\/span> BY<\/span>
\nbs.<\/span>backup_start_date DESC<\/span>
\n)<\/span> AS<\/span> BackupFiles
\nORDER<\/span> BY<\/span> database_name DESC<\/span>;<\/span><\/p>\n

— \u786e\u4fdd\u627e\u5230\u4e86\u5907\u4efd\u6587\u4ef6<\/span>
\nIF<\/span> @FileName<\/span> IS<\/span> NULL<\/span>
\nBEGIN<\/span>
\n RAISERROR<\/span>(<\/span>''<\/span>\u672a\u627e\u5230\u6709\u6548\u7684\u5907\u4efd\u6587\u4ef6''<\/span>,<\/span> 16<\/span>,<\/span> 1<\/span>)<\/span>;<\/span>
\n RETURN<\/span>;<\/span>
\nEND<\/span><\/p>\n

PRINT<\/span> ''<\/span>\u6b63\u5728\u4ece\u6587\u4ef6: ''<\/span> +<\/span> @FileName<\/span> +<\/span> ''<\/span> \u8fd8\u539f\u6570\u636e\u5e93.<\/span>.<\/span>.<\/span>''<\/span>;<\/span><\/p>\n

— \u68c0\u67e5\u6d4b\u8bd5\u5e93\u662f\u5426\u5b58\u5728，\u5b58\u5728\u5219\u7f6e\u4e3a\u5355\u7528\u6237\u6a21\u5f0f<\/span>
\nIF<\/span> DB_ID(<\/span>@TestDBName<\/span>)<\/span> IS<\/span> NOT<\/span> NULL<\/span>
\nBEGIN<\/span>
\n EXEC<\/span>(<\/span>''<\/span>ALTER<\/span> DATABASE<\/span> ''<\/span> +<\/span> @TestDBName<\/span> +<\/span> ''<\/span> SET<\/span> SINGLE_USER WITH<\/span> ROLLBACK<\/span> IMMEDIATE''<\/span>)<\/span>;<\/span><\/p>\n

— \u4f7f\u7528REPLACE\u9009\u9879\u8986\u76d6\u73b0\u6709\u6570\u636e\u5e93<\/span>
\n RESTORE<\/span> DATABASE<\/span> @TestDBName<\/span>
\n FROM<\/span> DISK<\/span> =<\/span> @FileName<\/span>
\n WITH<\/span> REPLACE<\/span>,<\/span>
\n MOVE ''<\/span>LGJLLOG''<\/span> TO<\/span> ''<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\DATA<\/span>\\\\LGJLLOG.<\/span>mdf''<\/span>,<\/span>
\n MOVE ''<\/span>LGJLLOG_Log''<\/span> TO<\/span> ''<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\DATA<\/span>\\\\LGJLLOG.<\/span>ldf''<\/span>,<\/span>
\n STATS =<\/span> 10<\/span>,<\/span> RECOVERY;<\/span><\/p>\n

EXEC<\/span>(<\/span>''<\/span>ALTER<\/span> DATABASE<\/span> ''<\/span> +<\/span> @TestDBName<\/span> +<\/span> ''<\/span> SET<\/span> MULTI_USER''<\/span>)<\/span>;<\/span>
\nEND<\/span>
\nELSE<\/span>
\nBEGIN<\/span>
\n — \u6570\u636e\u5e93\u4e0d\u5b58\u5728\u7684\u60c5\u51b5<\/span>
\n RESTORE<\/span> DATABASE<\/span> @TestDBName<\/span>
\n FROM<\/span> DISK<\/span> =<\/span> @FileName<\/span>
\n WITH<\/span>
\n MOVE ''<\/span>LGJLLOG''<\/span> TO<\/span> ''<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\DATA<\/span>\\\\LGJLLOG.<\/span>mdf''<\/span>,<\/span>
\n MOVE ''<\/span>LGJLLOG_Log''<\/span> TO<\/span> ''<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\DATA<\/span>\\\\LGJLLOG.<\/span>ldf''<\/span>,<\/span>
\n STATS =<\/span> 10<\/span>,<\/span> RECOVERY;<\/span>
\nEND<\/span><\/p>\n

PRINT<\/span> ''<\/span>\u6570\u636e\u5e93\u8fd8\u539f\u5b8c\u6210''<\/span>;<\/span><\/p>\n

— \u67e5\u8be2\u5907\u4efd\u6587\u4ef6\u903b\u8f91\u540d<\/span>
\n\/*
\nRESTORE FILELISTONLY
\nFROM DISK = ''E:\\\\Program Files\\\\Microsoft SQL Server\\\\MSSQL16.MSSQLSERVER\\\\MSSQL\\\\Backup\\\\LGJLLOG_20250518_060000.bak''
\n*\/<\/span><\/p>\n

— <\/span>
\n–IF DB_ID(''LGJLLOG'') IS NOT NULL <\/span>
\n–BEGIN <\/span>
\n–PRINT ''hello''<\/span>
\n–END', <\/span>
\n@database_name<\/span>=<\/span>N'master'<\/span>,<\/span>
\n@flags<\/span>=<\/span>0<\/span>
\nIF<\/span> (<\/span>@@ERROR<\/span> <><\/span> 0<\/span> OR<\/span> @ReturnCode<\/span> <><\/span> 0<\/span>)<\/span> GOTO<\/span> QuitWithRollback
\nEXEC<\/span> @ReturnCode<\/span> =<\/span> msdb.<\/span>dbo.<\/span>sp_update_job @job_id<\/span> =<\/span> @jobId<\/span>,<\/span> @start_step_id<\/span> =<\/span> 1<\/span>
\nIF<\/span> (<\/span>@@ERROR<\/span> <><\/span> 0<\/span> OR<\/span> @ReturnCode<\/span> <><\/span> 0<\/span>)<\/span> GOTO<\/span> QuitWithRollback
\nEXEC<\/span> @ReturnCode<\/span> =<\/span> msdb.<\/span>dbo.<\/span>sp_add_jobschedule @job_id<\/span>=<\/span>@jobId<\/span>,<\/span> @name<\/span>=<\/span>N'\u6bcf\u65e5\u4e0a\u53486\u70b940\u8fd8\u539f'<\/span>,<\/span>
\n@enabled<\/span>=<\/span>1<\/span>,<\/span>
\n@freq_type<\/span>=<\/span>4<\/span>,<\/span>
\n@freq_interval<\/span>=<\/span>1<\/span>,<\/span>
\n@freq_subday_type<\/span>=<\/span>1<\/span>,<\/span>
\n@freq_subday_interval<\/span>=<\/span>0<\/span>,<\/span>
\n@freq_relative_interval<\/span>=<\/span>0<\/span>,<\/span>
\n@freq_recurrence_factor<\/span>=<\/span>0<\/span>,<\/span>
\n@active_start_date<\/span>=<\/span>20250516<\/span>,<\/span>
\n@active_end_date<\/span>=<\/span>99991231<\/span>,<\/span>
\n@active_start_time<\/span>=<\/span>64000<\/span>,<\/span>
\n@active_end_time<\/span>=<\/span>235959<\/span>,<\/span>
\n@schedule_uid<\/span>=<\/span>N'997b734c-3e6d-4a9b-961a-5a745a56878d'<\/span>
\nIF<\/span> (<\/span>@@ERROR<\/span> <><\/span> 0<\/span> OR<\/span> @ReturnCode<\/span> <><\/span> 0<\/span>)<\/span> GOTO<\/span> QuitWithRollback
\nEXEC<\/span> @ReturnCode<\/span> =<\/span> msdb.<\/span>dbo.<\/span>sp_add_jobserver @job_id<\/span> =<\/span> @jobId<\/span>,<\/span> @server_name<\/span> =<\/span> N'(local)'<\/span>
\nIF<\/span> (<\/span>@@ERROR<\/span> <><\/span> 0<\/span> OR<\/span> @ReturnCode<\/span> <><\/span> 0<\/span>)<\/span> GOTO<\/span> QuitWithRollback
\nCOMMIT<\/span> TRANSACTION<\/span>
\nGOTO<\/span> EndSave
\nQuitWithRollback:
\n IF<\/span> (<\/span>@@TRANCOUNT<\/span> ><\/span> 0<\/span>)<\/span> ROLLBACK<\/span> TRANSACTION<\/span>
\nEndSave:
\nGO<\/p>\n

\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

DECLARE<\/span> @DBName<\/span> NVARCHAR(<\/span>128<\/span>)<\/span> =<\/span> 'LGJL'<\/span>;<\/span>
\nDECLARE<\/span> @TestDBName<\/span> NVARCHAR(<\/span>128<\/span>)<\/span> =<\/span> 'LGJL'<\/span>;<\/span> — \u6d4b\u8bd5\u73af\u5883\u4f7f\u7528\u4e0d\u540c\u540d\u79f0<\/span>
\nDECLARE<\/span> @BackupPath<\/span> NVARCHAR(<\/span>512<\/span>)<\/span> =<\/span> N'E:\\\\Program Files\\\\Microsoft SQL Server\\\\MSSQL16.MSSQLSERVER\\\\MSSQL\\\\Backup\\\\';
\nDECLARE @FileName NVARCHAR(512);<\/p>\n

— \u67e5\u627e\u6700\u65b0\u7684\u5907\u4efd\u6587\u4ef6（\u6309\u65e5\u671f\u6392\u5e8f）
\nSELECT TOP 1 @FileName = @BackupPath + '<\/span>LGJL' + '<\/span>_' + CONVERT(VARCHAR(8), GETDATE(), 112) + '<\/span>_' + '<\/span>060000.<\/span>bak' –physical_device_name
\nFROM (
\n SELECT top 1
\nbs.backup_set_id,
\nbs.database_name,
\nbs.backup_start_date,
\nbs.backup_finish_date,
\nbs.type AS backup_type,
\nCASE bs.type
\nWHEN '<\/span>D' THEN '<\/span>\u5b8c\u6574\u5907\u4efd'
\nWHEN '<\/span>I' THEN '<\/span>\u5dee\u5f02\u5907\u4efd'
\nWHEN '<\/span>L' THEN '<\/span>\u65e5\u5fd7\u5907\u4efd'
\nEND AS backup_type_desc,
\nbs.backup_size \/ 1024 \/ 1024 AS backup_size_MB,
\nbmf.physical_device_name
\nFROM
\n[10.101.10.252].[msdb].[dbo].[backupset] bs
\nINNER JOIN
\n[10.101.10.252].[msdb].[dbo].[backupmediafamily] bmf ON bs.media_set_id = bmf.media_set_id
\nWHERE bs.database_name LIKE '<\/span>%<\/span>' + @DBName + '<\/span>%<\/span>'
\nORDER BY
\nbs.backup_start_date DESC
\n) AS BackupFiles
\nORDER BY database_name DESC;<\/p>\n

— \u786e\u4fdd\u627e\u5230\u4e86\u5907\u4efd\u6587\u4ef6
\nIF @FileName IS NULL
\nBEGIN
\n RAISERROR('<\/span>\u672a\u627e\u5230\u6709\u6548\u7684\u5907\u4efd\u6587\u4ef6', 16, 1);
\n RETURN;
\nEND<\/p>\n

PRINT '<\/span>\u6b63\u5728\u4ece\u6587\u4ef6: ' + @FileName + '<\/span> \u8fd8\u539f\u6570\u636e\u5e93.<\/span>.<\/span>.<\/span>';<\/p>\n

— \u68c0\u67e5\u6d4b\u8bd5\u5e93\u662f\u5426\u5b58\u5728，\u5b58\u5728\u5219\u7f6e\u4e3a\u5355\u7528\u6237\u6a21\u5f0f
\nIF DB_ID(@TestDBName) IS NOT NULL
\nBEGIN
\n EXEC('<\/span>ALTER<\/span> DATABASE<\/span> ' + @TestDBName + '<\/span> SET<\/span> SINGLE_USER WITH<\/span> ROLLBACK<\/span> IMMEDIATE');<\/p>\n

— \u4f7f\u7528REPLACE\u9009\u9879\u8986\u76d6\u73b0\u6709\u6570\u636e\u5e93
\n RESTORE DATABASE @TestDBName
\n FROM DISK = @FileName
\n WITH REPLACE,
\n MOVE '<\/span>LGJL_Data' TO '<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\DATA<\/span>\\\\LGJL.<\/span>mdf',
\n MOVE '<\/span>LGJL_Log' TO '<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\DATA<\/span>\\\\LGJL.<\/span>ldf',
\n STATS = 10, RECOVERY;<\/p>\n

EXEC('<\/span>ALTER<\/span> DATABASE<\/span> ' + @TestDBName + '<\/span> SET<\/span> MULTI_USER');
\nEND
\nELSE
\nBEGIN
\n — \u6570\u636e\u5e93\u4e0d\u5b58\u5728\u7684\u60c5\u51b5
\n RESTORE DATABASE @TestDBName
\n FROM DISK = @FileName
\n WITH
\n MOVE '<\/span>LGJL_Data' TO '<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\DATA<\/span>\\\\LGJL.<\/span>mdf',
\n MOVE '<\/span>LGJL_Log' TO '<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\DATA<\/span>\\\\LGJL.<\/span>ldf',
\n STATS = 10, RECOVERY;
\nEND<\/p>\n

PRINT '<\/span>\u6570\u636e\u5e93\u8fd8\u539f\u5b8c\u6210';<\/p>\n

— \u67e5\u8be2\u5907\u4efd\u6587\u4ef6\u903b\u8f91\u540d
\n\/*
\nRESTORE FILELISTONLY
\nFROM DISK = '<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\Backup<\/span>\\\\LGJL_20250518_060000.<\/span>bak'
\n*\/<\/p>\n

—
\n–IF DB_ID('<\/span>LGJL') IS NOT NULL
\n–BEGIN
\n–PRINT '<\/span>hello'
\n–END <\/span><\/p>\n

\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

DECLARE<\/span> @DBName<\/span> NVARCHAR(<\/span>128<\/span>)<\/span> =<\/span> 'LGJLLOG'<\/span>;<\/span>
\nDECLARE<\/span> @TestDBName<\/span> NVARCHAR(<\/span>128<\/span>)<\/span> =<\/span> 'LGJLLOG'<\/span>;<\/span> — \u6d4b\u8bd5\u73af\u5883\u4f7f\u7528\u4e0d\u540c\u540d\u79f0<\/span>
\nDECLARE<\/span> @BackupPath<\/span> NVARCHAR(<\/span>512<\/span>)<\/span> =<\/span> N'E:\\\\Program Files\\\\Microsoft SQL Server\\\\MSSQL16.MSSQLSERVER\\\\MSSQL\\\\Backup\\\\';
\nDECLARE @FileName NVARCHAR(512);<\/p>\n

— \u67e5\u627e\u6700\u65b0\u7684\u5907\u4efd\u6587\u4ef6（\u6309\u65e5\u671f\u6392\u5e8f）
\nSELECT TOP 1 @FileName = @BackupPath + '<\/span>LGJLLOG' + '<\/span>_' + CONVERT(VARCHAR(8), GETDATE(), 112) + '<\/span>_' + '<\/span>060000.<\/span>bak' –physical_device_name
\nFROM (
\n SELECT top 1
\nbs.backup_set_id,
\nbs.database_name,
\nbs.backup_start_date,
\nbs.backup_finish_date,
\nbs.type AS backup_type,
\nCASE bs.type
\nWHEN '<\/span>D' THEN '<\/span>\u5b8c\u6574\u5907\u4efd'
\nWHEN '<\/span>I' THEN '<\/span>\u5dee\u5f02\u5907\u4efd'
\nWHEN '<\/span>L' THEN '<\/span>\u65e5\u5fd7\u5907\u4efd'
\nEND AS backup_type_desc,
\nbs.backup_size \/ 1024 \/ 1024 AS backup_size_MB,
\nbmf.physical_device_name
\nFROM
\n[10.101.10.252].[msdb].[dbo].[backupset] bs
\nINNER JOIN
\n[10.101.10.252].[msdb].[dbo].[backupmediafamily] bmf ON bs.media_set_id = bmf.media_set_id
\nWHERE bs.database_name LIKE '<\/span>%<\/span>' + @DBName + '<\/span>%<\/span>'
\nORDER BY
\nbs.backup_start_date DESC
\n) AS BackupFiles
\nORDER BY database_name DESC;<\/p>\n

— \u786e\u4fdd\u627e\u5230\u4e86\u5907\u4efd\u6587\u4ef6
\nIF @FileName IS NULL
\nBEGIN
\n RAISERROR('<\/span>\u672a\u627e\u5230\u6709\u6548\u7684\u5907\u4efd\u6587\u4ef6', 16, 1);
\n RETURN;
\nEND<\/p>\n

PRINT '<\/span>\u6b63\u5728\u4ece\u6587\u4ef6: ' + @FileName + '<\/span> \u8fd8\u539f\u6570\u636e\u5e93.<\/span>.<\/span>.<\/span>';<\/p>\n

— \u68c0\u67e5\u6d4b\u8bd5\u5e93\u662f\u5426\u5b58\u5728，\u5b58\u5728\u5219\u7f6e\u4e3a\u5355\u7528\u6237\u6a21\u5f0f
\nIF DB_ID(@TestDBName) IS NOT NULL
\nBEGIN
\n EXEC('<\/span>ALTER<\/span> DATABASE<\/span> ' + @TestDBName + '<\/span> SET<\/span> SINGLE_USER WITH<\/span> ROLLBACK<\/span> IMMEDIATE');<\/p>\n

— \u4f7f\u7528REPLACE\u9009\u9879\u8986\u76d6\u73b0\u6709\u6570\u636e\u5e93
\n RESTORE DATABASE @TestDBName
\n FROM DISK = @FileName
\n WITH REPLACE,
\n MOVE '<\/span>LGJLLOG' TO '<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\DATA<\/span>\\\\LGJLLOG.<\/span>mdf',
\n MOVE '<\/span>LGJLLOG_Log' TO '<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\DATA<\/span>\\\\LGJLLOG.<\/span>ldf',
\n STATS = 10, RECOVERY;<\/p>\n

EXEC('<\/span>ALTER<\/span> DATABASE<\/span> ' + @TestDBName + '<\/span> SET<\/span> MULTI_USER');
\nEND
\nELSE
\nBEGIN
\n — \u6570\u636e\u5e93\u4e0d\u5b58\u5728\u7684\u60c5\u51b5
\n RESTORE DATABASE @TestDBName
\n FROM DISK = @FileName
\n WITH
\n MOVE '<\/span>LGJLLOG' TO '<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\DATA<\/span>\\\\LGJLLOG.<\/span>mdf',
\n MOVE '<\/span>LGJLLOG_Log' TO '<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\DATA<\/span>\\\\LGJLLOG.<\/span>ldf',
\n STATS = 10, RECOVERY;
\nEND<\/p>\n

PRINT '<\/span>\u6570\u636e\u5e93\u8fd8\u539f\u5b8c\u6210';<\/p>\n

— \u67e5\u8be2\u5907\u4efd\u6587\u4ef6\u903b\u8f91\u540d
\n\/*
\nRESTORE FILELISTONLY
\nFROM DISK = '<\/span>E:\\\\Program Files\\\\Microsoft SQL<\/span> Server\\\\MSSQL16.<\/span>MSSQLSERVER\\\\MSSQL\\\\Backup<\/span>\\\\LGJLLOG_20250518_060000.<\/span>bak'
\n*\/<\/p>\n

—
\n–IF DB_ID('<\/span>LGJLLOG') IS NOT NULL
\n–BEGIN
\n–PRINT '<\/span>hello'
\n–END<\/span><\/p>\n

\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n","protected":false},"excerpt":{"rendered":"

10.101.10.252 \u670d\u52a1\u5668\u662f\u751f\u4ea7\u6570\u636e\u5e93\u670d\u52a1\u5668，10.80.189.43 \u670d\u52a1\u5668\u662f\u5f00\u53d1\u6d4b\u8bd5\u670d\u52a1\u5668，\u60f3\u8981\u5c06 10.101.10.252 \u4e0a\u7684\u751f\u4ea7\u5e93\u6bcf\u5929\u65e9\u4e0a6\u70b9\u5907\u4efd\u8fd8\u539f\u5230 10.80.189.43 \u4e0a，\u64cd\u4f5c\u5982\u4e0b：
\n\u9996\u5148\u5728 10.101.10.252 \u4e0a\u9762\u521b\u5efa\u4e00\u4e2a SQL Server \u4ee3\u7406\u4f5c\u4e1a，\u4ee5\u5b9a\u65f6\u5907\u4efd\u6570\u636e\u5e93，\u5982\u4e0b：
\nUSE [msdb]
\nGO\/****** Object: <\/p>\n","protected":false},"author":2,"featured_media":79657,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[8896,8894,8893,8895,538],"topic":[],"class_list":["post-79677","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-8896","tag-8894","tag-8893","tag-8895","tag-sqlserver"],"yoast_head":"\nSQL Server\u81ea\u52a8\u5b9a\u65f6\u5907\u4efd\u8fd8\u539f\u5230\u53e6\u4e00\u53f0\u670d\u52a1\u5668 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/79677.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server\u81ea\u52a8\u5b9a\u65f6\u5907\u4efd\u8fd8\u539f\u5230\u53e6\u4e00\u53f0\u670d\u52a1\u5668 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"10.101.10.252 \u670d\u52a1\u5668\u662f\u751f\u4ea7\u6570\u636e\u5e93\u670d\u52a1\u5668，10.80.189.43 \u670d\u52a1\u5668\u662f\u5f00\u53d1\u6d4b\u8bd5\u670d\u52a1\u5668，\u60f3\u8981\u5c06 10.101.10.252 \u4e0a\u7684\u751f\u4ea7\u5e93\u6bcf\u5929\u65e9\u4e0a6\u70b9\u5907\u4efd\u8fd8\u539f\u5230 10.80.189.43 \u4e0a，\u64cd\u4f5c\u5982\u4e0b： \u9996\u5148\u5728 10.101.10.252 \u4e0a\u9762\u521b\u5efa\u4e00\u4e2a SQL Server \u4ee3\u7406\u4f5c\u4e1a，\u4ee5\u5b9a\u65f6\u5907\u4efd\u6570\u636e\u5e93，\u5982\u4e0b： USE [msdb] GO\/****** Object:\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/79677.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-03-02T11:32:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/03\/20260302113222-69a575463325a.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/79677.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/79677.html\",\"name\":\"SQL Server\u81ea\u52a8\u5b9a\u65f6\u5907\u4efd\u8fd8\u539f\u5230\u53e6\u4e00\u53f0\u670d\u52a1\u5668 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-03-02T11:32:27+00:00\",\"dateModified\":\"2026-03-02T11:32:27+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/79677.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/79677.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/79677.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server\u81ea\u52a8\u5b9a\u65f6\u5907\u4efd\u8fd8\u539f\u5230\u53e6\u4e00\u53f0\u670d\u52a1\u5668\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server\u81ea\u52a8\u5b9a\u65f6\u5907\u4efd\u8fd8\u539f\u5230\u53e6\u4e00\u53f0\u670d\u52a1\u5668 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/79677.html","og_locale":"zh_CN","og_type":"article","og_title":"SQL Server\u81ea\u52a8\u5b9a\u65f6\u5907\u4efd\u8fd8\u539f\u5230\u53e6\u4e00\u53f0\u670d\u52a1\u5668 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"10.101.10.252 \u670d\u52a1\u5668\u662f\u751f\u4ea7\u6570\u636e\u5e93\u670d\u52a1\u5668，10.80.189.43 \u670d\u52a1\u5668\u662f\u5f00\u53d1\u6d4b\u8bd5\u670d\u52a1\u5668，\u60f3\u8981\u5c06 10.101.10.252 \u4e0a\u7684\u751f\u4ea7\u5e93\u6bcf\u5929\u65e9\u4e0a6\u70b9\u5907\u4efd\u8fd8\u539f\u5230 10.80.189.43 \u4e0a，\u64cd\u4f5c\u5982\u4e0b： \u9996\u5148\u5728 10.101.10.252 \u4e0a\u9762\u521b\u5efa\u4e00\u4e2a SQL Server \u4ee3\u7406\u4f5c\u4e1a，\u4ee5\u5b9a\u65f6\u5907\u4efd\u6570\u636e\u5e93，\u5982\u4e0b： USE [msdb] GO\/****** Object:","og_url":"https:\/\/www.wsisp.com\/helps\/79677.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-03-02T11:32:27+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/03\/20260302113222-69a575463325a.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"11 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/79677.html","url":"https:\/\/www.wsisp.com\/helps\/79677.html","name":"SQL Server\u81ea\u52a8\u5b9a\u65f6\u5907\u4efd\u8fd8\u539f\u5230\u53e6\u4e00\u53f0\u670d\u52a1\u5668 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-03-02T11:32:27+00:00","dateModified":"2026-03-02T11:32:27+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/79677.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/79677.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/79677.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"SQL Server\u81ea\u52a8\u5b9a\u65f6\u5907\u4efd\u8fd8\u539f\u5230\u53e6\u4e00\u53f0\u670d\u52a1\u5668"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/79677","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=79677"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/79677\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/79657"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=79677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=79677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=79677"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=79677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}