title: How to build a script to backup all databases in SQL Server?
body: <p>We need to backup 40 databases inside a SQL Server instance.  We backup each database with the following script:</p>
  
  <pre><code>BACKUP DATABASE [dbname1] TO  DISK = N'J:\SQLBACKUPS\dbname1.bak' WITH NOFORMAT, INIT,  NAME = N'dbname1-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
  GO
  declare @backupSetId as int
  select @backupSetId = position from msdb..backupset where database_name=N'dbname1' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'dbname1' )
  if @backupSetId is null begin raiserror(N'Verify failed. Backup information for database ''dbname1'' not found.', 16, 1) end
  RESTORE VERIFYONLY FROM  DISK = N'J:\SQLBACKUPS\dbname1.bak' WITH  FILE = @backupSetId,  NOUNLOAD,  NOREWIND
  GO
  </code></pre>
  
  <p>We will like to add to the script the functionality of taking each database and replacing it in the above script. Basically a script that will create and verify each database backup from an engine.</p>
  
  <p>I am looking for something like this:</p>
  
  <pre><code>For each database in database-list
      sp_backup(database) // this is the call to the script above.
  End For
  </code></pre>
  
  <p>any ideas?</p>