Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @name VARCHAR(50) -- database name
- DECLARE @path VARCHAR(256) -- path for backup files
- DECLARE @fileName VARCHAR(256) -- filename for backup
- DECLARE @fileDate VARCHAR(20) -- used for file name
- SET @path = 'E:\db-backup\2019w07.2019-02-11.Operation\'
- SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)
- DECLARE db_cursor CURSOR FOR
- SELECT name
- FROM master.dbo.sysdatabases
- WHERE name IN ('u')
- 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 COPY_ONLY, NOFORMAT, COMPRESSION
- FETCH NEXT FROM db_cursor INTO @name
- END
- CLOSE db_cursor
- DEALLOCATE db_cursor
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement