Backing up Logs for multiple databases.
jhboricua
Posts: 41
To do either a full or diff backup of all my user databases I can use:
What's the proper way to do Log backups on all user databases? When I look at the BACKUP command page on Red Gate Support, I don't see an option to use USER DATABASES listed for log backups.
Can someone clarify what's the proper syntax?
Is it:
EXECUTE master..sqlbackup '-SQL "BACKUP USER DATABASES TO DISK....
What's the proper way to do Log backups on all user databases? When I look at the BACKUP command page on Red Gate Support, I don't see an option to use USER DATABASES listed for log backups.
Can someone clarify what's the proper syntax?
Is it:
EXECUTE master..sqlbackup '-SQL "BACKUP USER LOGS TO DISK....???
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
After some more reading I found that doing:
was the way to go. This backs up all my user databases while excluding the model database.