MAINSERVER (SQL Server 2000/2005),需備份 msdb。DAVID (Windows),共享資料夾 E:\Test。DOMAIN\zf / 密碼 123。DAVID 上執行或遠程):NET SHARE Test=E:\Test /GRANT:DOMAIN\zf,FULL
MAINSERVER 的查詢分析器執行):EXEC master..xp_cmdshell 'NET USE \\DAVID\Test 123 /USER:DOMAIN\zf';
xp_cmdshell 以 SQL Server 服務帳號身分執行命令,**需 sysadmin 固定伺服器角色**。
BACKUP DATABASE msdb TO DISK = '\\DAVID\Test\msdb.bak'
WITH INIT, STATS = 10; -- 覆寫、每 10% 顯示進度
EXEC master..xp_cmdshell 'NET USE \\DAVID\Test /DELETE';
RESTORE DATABASE msdb FROM DISK = '\\DAVID\Test\msdb.bak'
WITH REPLACE, STATS = 10;
xp_cmdshell **極度危險**:允許 T-SQL 執行任意作業系統命令,**僅限 sysadmin 使用**,許多 DBA 直接刪除或拒絕執行權限:EXEC sp_dropextendedproc 'xp_cmdshell'; 或 DENY EXEC ON xp_cmdshell TO public;。Processed 1376 pages for database 'msdb', file 'MSDBData' on file 1.
Processed 1 pages for database 'msdb', file 'MSDBLog' on file 1.
BACKUP DATABASE successfully processed 1377 pages in 3.653 seconds (3.086 MB/sec).