SQL Server 2005 Books Online
BACKUP (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms186865.aspx
BACKUP (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms186865.aspx
A. Backing up a complete database
The following example backs up the AdventureWorks database to a disk file.
BACKUP DATABASE AdventureWorks TO DISK = 'Z:\SQLServerBackups\AdvWorksData.bak' WITH FORMAT; GO
简单一点在.sql文件中放置多个BACKUP SQL, 就可以完成执行一个步骤就可以生成多个数据库备份