SET NOCOUNT ON DECLARE @Time nvarchar(19), @Path nvarchar(400), @NameMain nvarchar(100), @NameFile nvarchar(100), @PathMain nvarchar(1000), @PathFile nvarchar(1000) --upravit cestu dle skutecne cesty cile zalohy na serveru SET @Path = '#CESTA_K_CILOVEMU_ADRESARI#' --'C:\backup', musi existovat --mozno zmenit vychozi nazvy DB dle skutecnosti SET @NameMain = 'ISENVITA' SET @NameFile = 'ISENVITA_Files' --ziskani cesoveho razitka SET @Time = REPLACE(REPLACE(CONVERT(nvarchar(19), GETDATE(), 120),':','-'),' ','_') --sestaveni cesty k zaloznimu souboru SET @PathMain = @Path+'\'+@NameMain+'_'+@Time+'.bak' SET @PathFile = @Path+'\'+@NameFile+'_'+@Time+'.bak' --provedeni zalohy print '===================' print @Time print 'START backup: '+@PathMain BACKUP DATABASE @NameMain TO DISK = @PathMain WITH INIT print 'START backup: '+@PathFile BACKUP DATABASE @NameFile TO DISK = @PathFile WITH INIT |