65.9K
CodeProject is changing. Read more.
Home

Keeping a Database Server Healthy

emptyStarIconemptyStarIconemptyStarIconemptyStarIconemptyStarIcon

0/5 (0 vote)

Apr 11, 2011

CPOL
viewsIcon

3710

Actually, we think xp_cmdshell is not safe enough, and need to be enabled using surface area configuration explicitly (SQL 2005). We use xp_delete_file instead, sample code:DECLARE @l_Runtime DATETIME, @l_BackupFileName VARCHAR(256), @l_FileExists INTSET...

Actually, we think xp_cmdshell is not safe enough, and need to be enabled using surface area configuration explicitly (SQL 2005). We use xp_delete_file instead, sample code:
DECLARE @l_Runtime        DATETIME,
        @l_BackupFileName VARCHAR(256),
        @l_FileExists     INT
SET @l_Runtime = GETDATE()
SET @l_BackupFileName = ...
EXEC master.dbo.xp_fileexist @l_BackupFileName, @l_FileExists OUTPUT
IF @l_FileExists = 1
BEGIN
   EXECUTE master.dbo.xp_delete_file 0, @l_BackupFileName, '', @l_Runtime
END