salut, am si eu nevoie de ajutorul vostru cat :(

am procedura care creeaza un backup astfel

CREATE     proc _BackUp
 @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)

declare @i int
select
 @luna=cast(month(GETDATE()) as nvarchar(50)),
 @i=cast(@luna as int)-1

if len(@luna)=1 set @luna='0'+cast(@luna as nvarchar(50))

-- 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\FolderTEST\TEST_'+@now
set @CaleBackup=@CaleBackup0+'.BAK'
set @LogicalBackup='TEST_'+@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 TEST TO '+@LogicalBackup)

set @param=1

return @param

GO

problema e ca vreau sa includ in procedura si sa-mi creeze folderul in care pun backupul daca el nu exista in cazul meu "FolderTEST" pentru ca imi da eroare daca nu exista folderul in care vrea sa-si puna backupul facut de procedura

Multumesc mult.