MS-SQL
동적쿼리로 백업 하기
팔개
2014. 4. 13. 00:23
DECLARE @SQL NVARCHAR(4000)
SET @SQL = 'BACKUP DATABASE B2CDB TO DISK = ''D:\DBFile\B2CDB'+REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(20),GETDATE(),120),'-',''),' ',''),':','')+'.bak'''
EXECUTE SP_EXECUTESQL @SQL
SELECT CONVERT(VARCHAR(10),GETDATE(),120)