Hi,
We use sqlfull.cmd to take full backup once a day with a few log backups. We have a problem when a ms sql instance has hundreds of databases. Some databases have status: simple. This means that the log backup fails and makes a lot of noise in the reporting system.
Is it possible to drop log backup to take a full backup of databases which have status: simple, or new created databases with missing full backup?
Thanks!
We use sqlfull.cmd to take full backup once a day with a few log backups. We have a problem when a ms sql instance has hundreds of databases. Some databases have status: simple. This means that the log backup fails and makes a lot of noise in the reporting system.
Is it possible to drop log backup to take a full backup of databases which have status: simple, or new created databases with missing full backup?
Thanks!