I'm after a bit of advice. I work in an environment where we have around
databases across around 20 servers. When considering backing up the logs
tend to struggle as to what is the best way. New test databases are created
right and centre, the server they are hosted on changes from time to time
and the
drive logs are written to can also change.

Does anyone have any experience of this kind of operation or can anyone
suggest any clever ways to ensure we backup everything necessary.