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.

Async SQL Backup

SQL Log Backup

Let me know what you think!

Advertisements

About jrich

I am the Solutions Architect for Apex Learning in Seattle WA. I've been working with computers since I was 13. Started programming when I was 14. Had my first IT job as tech support at an ISP at the age of 15 and became a network admin at the age of 17. Since then I've worked at a variety of small to mid size companies supporting, maintaining and developing all aspects of IT. Mostly working with Windows based networks but have recently been working with Solaris system as well. I created this blog mostly as a place for me to take my own notes, but also share things that I had a hard time finding the info for.

Posted on July 13, 2011, in WMF (Powershell/WinRM). Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: