Backup Non System Database
Author: Hemantgiri S. Goswami
Rating: Rate this Resource
Visits: 10091

Discuss in Newsgroups

declare @int int ,@dbname varchar(22)
set @int = 0
while (@int < 5)
begin
set @dbname = (select [name] from master..sysdatabases where dbid=@int)
  if (@dbname != 'tempdb')
  begin
   BACKUP DATABASE @dbname
   TO DISK = @dbname
   WITH INIT
  end  
  set @int = @int + 1  
 continue 
 break
end
Visit my guru profile

Visitor Comments

Be the first to rate this code sample!

Rate this Code Sample