Evo kako to ja radim:
Code:
if exists (select name from sys.procedures where name = 'BackupDatabase')
drop procedure BackupDatabase
go
create procedure BackupDatabase
@Baza varchar (50),
@Direktorij varchar(250),
@NazivDatoteke varchar (250)
with encryption as
declare @BazaPodataka varchar(50)
declare @Path varchar(250)
declare @Datoteka varchar(250)
set @Path = @Direktorij
declare db_cursor cursor for
select @Baza from master.dbo.sysdatabases where name not in ('master','model','msdb','tempdb')
open db_cursor
fetch next from db_cursor into @BazaPodataka
while @@fetch_status = 0
begin
set @Datoteka = @Direktorij + '\' + @NazivDatoteke + '.bak'
backup database @Baza to disk = @Datoteka
fetch next from db_cursor into @BazaPodataka
end
close db_cursor
deallocate db_cursor
--execute BackupDatabase 'TestBaza', 'C:\SQL', 'testbaza'
Radim u MS SQL Server 2005 i ovo radi.