SQL Async backup script
Do you have a large SQL server with a lot of databases that all need to be backed up overnight? Well I do, so I had to come up with a way to backup all databases at once.
I ran in to a little problem where the backup events were not updating the status so I had to do a little tom foolery with a timer.
Over all seems to work well but you can’t run them as a SQL Powershell job because the powershell that SQL uses is limited and some of the things I use in this script are not supported.
I created the full backup script and a tlog script which can be found on Posh or Technet
here are the links for technet.
Let me know what you think!