Backup po danima za sve baze

declare @cBaza varchar (1000)

declare @cPut varchar (1000)

declare btsPoz cursor local fast_forward for

select name from sysdatabases where name not in ('master','model','tempdb','msdb')

open btsPoz

fetch from btsPoz into @cBaza

while @@fetch_status = 0

begin

set @cPut = 'C:\PRENOS\' + rtrim(@cBaza)+'.bak'

BACKUP DATABASE @cBaza TO DISK = @cPut WITH INIT , NOUNLOAD , NAME = N'@cBaza', NOSKIP , STATS = 10, NOFORMAT

fetch from btsPoz into @cBaza

end

close btsPoz

deallocate btsPoz