Welcome to Sign in | Help

Re: cum creez un folder in T-SQL (SQLServer 2000)

  •  06-07-2007, 9:37 AM

    Re: cum creez un folder in T-SQL (SQLServer 2000)

    da...intradevar chiar  nu sunt sigur de parametrii pe care-i dau....dar nici nu inteleg cum as putea sa-i verific.....parametrii pe care-i dau acum i-am luat si eu dintr-o alta procedura care facea ceva asemanator......nu am inteles principiul deci nici nu stiu care sunt cei corecti :(....o iau si eu pe incercate....daca are cineva vreo idee sunt mai mult decat fericit sa o primesc.....

    multumesc

     P.S. daca vrea cineva sa incerce sa-i dea de cap...mai jos am pus procedura asa cum arata ea acum......


    create  proc _BackUp_DBName_WinRAR
     @DBName nvarchar(50),
     @param bit Out

    as
    set @param=0

    declare
     @now    nvarchar(100),
     @luna    nvarchar(10),
     @LogicalBackup   nvarchar(300),
     @CaleBackup0   nvarchar(300),
     @CaleBackup   nvarchar(300),
     @strSQL   nvarchar(4000)

    declare
     @dataRef datetime,
     @month int,
     @year int

    set @dataRef=getdate()
    set @month = datepart(mm,@dataRef)
    set @year = datepart(yyyy,@dataRef)


    select @luna=cast(month(GETDATE()) as nvarchar(50))


    if len(@luna)=1 set @luna='0'+cast(@luna as nvarchar(50))
    set  @strSQL='mkdir "D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\' + @DBName + '"'
    EXEC master..xp_cmdshell @strSQL
    -- Create a logical backup device for the full database backup
    set @now=cast(day(GETDATE()) as nvarchar(50))+''+@luna+''+cast(year(GETDATE()) as nvarchar(50))+'_'+cast(DATEPART(hour, GETDATE()) as nvarchar(50))+''+cast(DATEPART(minute, GETDATE()) as nvarchar(50))+''+cast(DATEPART(second, GETDATE()) as nvarchar(50))
    set @CaleBackup0='D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\TEST\'+@DBName + '_'+ @now
    set @CaleBackup=@CaleBackup0+'.BAK'
    set @LogicalBackup= @DBName + '_'+ @now

    print 'EXEC master..sp_addumpdevice ''disk'', '''+@LogicalBackup+''', '''+@CaleBackup+''''
    exec('EXEC master..sp_addumpdevice ''disk'', '''+@LogicalBackup+''', '''+@CaleBackup+'''')
    -- Back up the full database
    exec('BACKUP DATABASE ' + @DBName + ' TO ' + @LogicalBackup)

    DECLARE  @LocalBackUPPath   nvarchar(255),
      @LocalBackUPDrive  nvarchar(128), 
      @TemplateFileName  nvarchar(255),
      @TemplateCharSeparator  nvarchar(128),
      @tmpSQL    varchar(8000),
      @tmpServer   varchar(8000),
      @PackerFileName   nvarchar(255),
      @PackFileName   nvarchar(255),
      @SetPasswordAutomatic  bit,
      @SetPasswordTo    nvarchar(64),
      @PackOptions   nvarchar(255),
      @FileExtention   nvarchar(32)

    SET @PackerFileName = '"C:\Program Files\WinRAR\WinRAR.exe"'
    SET @PackOptions = 'a -s' -- -df -ep -d4096 -rr -ri1 -m5
    SET @LocalBackupDrive = 'D:'
    SET @LocalBackUPPath = 'Program Files\Microsoft SQL Server\MSSQL\BACKUP'
    SET @PackFileName=@LogicalBackup + '.BAK' --+ @FileExtention

    SET @tmpServer='master.dbo.xp_cmdshell'
    SET @tmpSQL=@PackerFileName + ' ' + @PackOptions + ' ' + @LocalBackupDrive + '\' + @LocalBackUPPath + '\' + @PackFileName + ' ' + @LocalBackupDrive + '\' + @LocalBackUPPath + '\' + @LogicalBackup
    EXEC master..xp_cmdshell @tmpSQL


    set @param=1

    return @param

    GO

     

    asa arata acel @tmpSQL care se formeaza si care se pare ca nu e ok.....

    '"C:\Program Files\WinRAR\WinRAR.exe" a -s D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\TEST_7062007_94649.BAK D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\TEST_7062007_94649'

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems