InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 15:41:12 GMT20http://www.sqlservercentral.com/Forums/Topic1239476-357-1.aspxTry [url=http://www.sqlbackupmaster.com]SQL Backup Master[/url], which can back up all non-system databases at once. Basic edition is free.Mon, 28 Jan 2013 10:19:22 GMTTodd Bellerhttp://www.sqlservercentral.com/Forums/Topic1239476-357-1.aspxOla Hallengren has a great script for that:[url]http://ola.hallengren.com/sql-server-backup.html[/url]No need to re-invent the wheel.Sun, 22 Jan 2012 14:48:18 GMTspaghettidbahttp://www.sqlservercentral.com/Forums/Topic1239476-357-1.aspxThanks a lot all. It works great.Fri, 20 Jan 2012 09:15:00 GMTespanolanthonyhttp://www.sqlservercentral.com/Forums/Topic1239476-357-1.aspx[quote][b]padhis (1/20/2012)[/b][hr][code="sql"]exec sp_msforeachdb 'if db_id(''?'')>4 backup database [?] to disk = ''C:\?.bak'' with init, compression;'[/code][/quote]Does the same thing but isn't support by Microsoft :-PFri, 20 Jan 2012 09:06:41 GMTRobert Murphy UK1http://www.sqlservercentral.com/Forums/Topic1239476-357-1.aspx[code="sql"]exec sp_msforeachdb 'if db_id(''?'')>4 backup database [?] to disk = ''C:\?.bak'' with init, compression;'[/code]Fri, 20 Jan 2012 08:56:29 GMTpadhishttp://www.sqlservercentral.com/Forums/Topic1239476-357-1.aspxDECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) -- filename for backup DECLARE @fileDate VARCHAR(20) -- used for file name SET @path = 'C:\Backup\' SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) DECLARE db_cursor CURSOR FOR SELECT name FROM master.dbo.sysdatabases WHERE name NOT IN ('master','model','msdb','tempdb') OPEN db_cursor FETCH NEXT FROM db_cursor INTO @name WHILE @@FETCH_STATUS = 0 BEGIN SET @fileName = @path + @name + '_' + @fileDate + '.BAK' BACKUP DATABASE @name TO DISK = @fileName WITH COMPRESSION FETCH NEXT FROM db_cursor INTO @name END CLOSE db_cursor DEALLOCATE db_cursorFri, 20 Jan 2012 08:27:53 GMTRobert Murphy UK1http://www.sqlservercentral.com/Forums/Topic1239476-357-1.aspxHi, Need a script to compress and backup all the databases in sql 2008, except system databases. Please let me know if someone has it.Thanks.Fri, 20 Jan 2012 07:56:28 GMTespanolanthony