DECLARE @name varchar(50) -- database name
DECLARE @path varchar(256) -- yedek dosya/klasör yolu
DECLARE @filename varchar(256) -- yedek dosya adı
DECLARE @filedate varchar(20) -- tarih
SET @path = 'E:\yedek\'
SET @filedate = CONVERT(VARCHAR(20), GETDATE(),112) + '_' + REPLACE(CONVERT(NVARCHAR(20),GETDATE(),108),':','')
DECLARE db_cursor CURSOR FOR
SELECT name FROM master.dbo.sysdatabases where name like 'CKR_A%' -- not in ('master','model','msdb','tempdb')
-- AND state = 0 -- database is online
-- AND is_in_standby = 0 -- database is not read only for log shipping
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 STATS=10, COMPRESSION
FETCH NEXT FROM db_cursor INTO @name
END
close db_cursor
deallocate db_cursor
