Backup SQL Server database accross more than one file
–====================================================
–= BACKUP database accross four files
–====================================================
declare @filedate nvarchar(100)
declare @disk1 nvarchar(100)
declare @disk2 nvarchar(100)
declare @disk3 nvarchar(100)
declare @disk4 nvarchar(100)
declare @dbname nvarchar(100)
declare @backupname nvarchar(100)
declare @backupfolder nvarchar(100)
set @dbname = ‘DBA’
set @backupfolder = ‘F:\SQLBackup\’ + @dbname + ‘\’
select @filedate = replace(replace(replace(replace(convert(nvarchar,getdate(),121),’-’,’_’),’ ‘,’_’),’:’,”),’.’,’_’)
select @backupname = @dbname + ‘_backup’ + @filedate
print @filedate
print @backupname
–select @filedate
select @disk1 = @backupfolder + @dbname + ‘_backup_File1_’ + [...]
