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'