quote:

---

BACKUP DATABASE { database_name | @database_name_var }
TO < backup_device > [ ,...n ]

---

quote:

---

When specifying multiple files, logical file names (or variables) and physical file names (or variables) can be mixed. However, all devices must be of the same type (disk, tape, or pipe).

n

Is a placeholder that indicates multiple backup devices may be specified. The maximum number of backup devices is 64.

---

USE master
GO

EXEC sp_addumpdevice 'disk', 'GT1',
   'E:\MSSQL$GTW1\BACKUP\GT1.dat'

EXEC sp_addumpdevice 'disk', 'GT2',
   'E:\MSSQL$GTW1\BACKUP\GT2.dat'

EXEC sp_addumpdevice 'disk', 'GT3',
   'E:\MSSQL$GTW1\BACKUP\GT3.dat'

EXEC sp_addumpdevice 'disk', 'GT4',
   'E:\MSSQL$GTW1\BACKUP\GT4.dat'

BACKUP DATABASE GT
TO GT1, GT2, GT3, GT4

quote:

---

Originally posted by tkizer

The best way to find out these things is to test it.

---

BACKUP DATABASE mydb TO DISK = 'F:\weeklybackup\mydb.BAK' WITH INIT

BACKUP DATABASE mydb TO DISK = 'F:\weeklybackup\mydb1.BAK', 
'F:\weeklybackup\mydb1.BAK' WITH INIT

USE master
GO

EXEC sp_addumpdevice 'disk', 'devnet1', 'F:\weeklybackup\devnet1.BAK'

EXEC sp_addumpdevice 'disk', 'devnet2', 'F:\weeklybackup\devnet2.BAK'

EXEC sp_addumpdevice 'disk', 'devnet3', 'F:\weeklybackup\devnet3.BAK'

EXEC sp_addumpdevice 'disk', 'devnet4', 'F:\weeklybackup\devnet4.BAK'

EXEC sp_addumpdevice 'disk', 'devnet5', 'F:\weeklybackup\devnet5.BAK'

EXEC sp_addumpdevice 'disk', 'devnet6', 'F:\weeklybackup\devnet6.BAK'

BACKUP DATABASE devnet 
TO devnet1, devnet2, devnet3, devnet4, devnet5, devnet6
WITH INIT

backup database msdb 
to 
	disk = 'C:\temp\msdb_1.bak', 
	disk = 'C:\temp\msdb_2.bak', 
	disk = 'C:\temp\msdb_3.bak', 
	disk = 'C:\temp\msdb_4.bak', 
	disk = 'C:\temp\msdb_5.bak', 
	disk = 'C:\temp\msdb_6.bak', 
	disk = 'C:\temp\msdb_7.bak', 
	disk = 'C:\temp\msdb_8.bak'
with 
	init,
	stats

quote:

---

Originally posted by Michael Valentine Jones

backup database msdb 
to 
	disk = 'C:\temp\msdb_1.bak', 
	disk = 'C:\temp\msdb_2.bak', 

---