Generate Scripts for Transactional Log Backups for All the User Databases on SQL Server

The below script can be use to generate Transactional Log backup scripts for all the user databases on SQL Server

Declare @BackupPath VARCHAR(100)
SEt @BackupPath='c:\Backup\'
Select 'LOG DATABASE ['+name+'] TO  DISK = N'''+@BackupPath+''+name+'.trn''
WITH NOFORMAT, NOINIT,  NAME = N'''+name+'-Full Database Backup'', SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10'

 from sys.databases
where database_id>4

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)