成人欧美一区二区三区的电影,日韩一级一欧美一级国产,国产成人国拍亚洲精品,无码人妻精品一区二区三区毛片,伊人久久无码大香线蕉综合

數(shù)據(jù)庫和日志文件備份

-- 1.允許修改高級選項(xiàng)

EXEC?sp_configure'show advanced options',?1;

RECONFIGURE;

GO

-- 2.啟用xp_cmdshell

EXEC?sp_configure'xp_cmdshell',?1;

RECONFIGURE;

GO

-- 3..禁用用xp_cmdshell

EXECsp_configure'xp_cmdshell',?0;

RECONFIGURE;

GO

EXECsp_configure'show advanced options',?0;

RECONFIGURE;

GO

-- 4.鏈接共享服務(wù)器

EXEC?xp_cmdshell'net use \\192.168.2.9\l /user:192.168.2.9\user "password"'

-- 5.測試數(shù)據(jù)庫是否能夠訪問共享服務(wù)器

EXEC?xp_cmdshell'dir \\192.168.2.9\l\'

-- 6.備份數(shù)據(jù)庫

--創(chuàng)建憑據(jù)（一次性設(shè)置）

USE?plmv8;

CREATECREDENTIAL?[BackupCredential2]

WITHIDENTITY='\\192.168.2.9\l\user',

SECRET='password';

PRINT'4.?憑證檢查:'

SELECTname,?credential_identity?FROMsys.credentials;

USEmaster;

--?清理舊憑據(jù)

IFEXISTS(SELECT?1?FROMsys.credentialsWHEREname='BackupCredential')

DROPCREDENTIAL?[BackupCredential2];

--?查看憑證是否存在

USEmaster;

IFNOTEXISTS(SELECT?1?FROMsys.credentialsWHEREname='BackupCredential')

BEGIN

CREATECREDENTIAL?[BackupCredential]

WITHIDENTITY='192.168.2.9\user',??

SECRET='password';

END

--?方法：使用動態(tài)SQL生成文件名

DECLARE@BackupPath?NVARCHAR(500)

DECLARE@FileName?NVARCHAR(100)

--?生成日期時間戳文件名

SET@FileName?='plmv8_backup_'+CONVERT(VARCHAR(8),GETDATE(),?112)+

?'_'+REPLACE(CONVERT(VARCHAR(8),GETDATE(),?108),':','')+'.trn'

SET@BackupPath?='\\192.168.2.9\l\'+?@FileName

--?執(zhí)行備份日志數(shù)據(jù)庫

BACKUP?LOG?[plmv8]

TODISK=?@BackupPath

WITH

CREDENTIAL='BackupCredential',

FORMAT,

COMPRESSION,

STATS=?10;

--?執(zhí)行備份數(shù)據(jù)庫

BACKUP?DATABASE?[plmv8]

TODISK=?@BackupPath

WITH

CREDENTIAL='BackupCredential',

FORMAT,

COMPRESSION,

STATS=?10;

?

閱讀原文：https://mp.weixin.qq.com/s/LBK9EEs2KdF-L5iqc9tLUg