InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 18:36:42 GMT20http://www.sqlservercentral.com/Forums/Topic402749-195-1.aspxI am also having a small script to backup all my databases.....Use MasterDECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName NVARCHAR(256) -- filename for backup DECLARE @fileDate VARCHAR(20) -- used for file nameSET @path = 'd:\Backup\' SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)SELECT name,flag=0 into #tempbackup FROM master.dbo.sysdatabases WHERE name NOT IN ('master','model','msdb','tempdb')set rowcount 1WHILE (exists(SELECT * FROM #tempbackup WHERE flag=0)) BEGIN Select @name=name from #tempbackup WHERE flag=0 SET @fileName = @path + @name + '_' + @fileDate + '.BAK' print @fileName BACKUP DATABASE @name TO DISK = @fileName Update #tempbackup set flag=1 WHERE flag=0 and name=@name END set rowcount 0drop table #tempbackupThu, 18 Jun 2009 23:50:39 GMTManish_http://www.sqlservercentral.com/Forums/Topic402749-195-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Backup+%2f+Restore/30066/">Stored Procedure to Backup all Databases</A>[/B]Tue, 25 Sep 2007 14:38:50 GMTWesley Brown