Tuesday, February 17, 2009

Activity to Prevent Brain Rot: SQLBackup v0.2

Over the past couple weeks, I've spent an hour or so putting together a quick and dirty application to backup some of our databases which reside on an instance of SQL Server 2008 Express. If you know anything about SQL Server Express, you know that it doesn't include or allow maintenance plans (such as scheduled backups) because MS has crippled the SQL Agent service.

... hence the reason I started writing my own little app.

v0.1
I started with some MSDN code and tidbits I found on other web sites. The first iteration connected to the SQL Server using hardcoded values and backed up every database. Not exactly the best method, but remember - I said quick and dirty.

v0.2
I just finished the second iteration of the app. Instead of backing up all databases on the server, it takes individual database names via command line arguments. This way, I gain a little more control over what databases I am backing up.

What's next?
Not sure. However, I know that I eventually want to get to the point where this app is managed via a little form/console, can run as a Windows service, and stores all of its configuration and database information in an XML file - with encrypted values for the database credentials.

Is that really complicated to do? No. But it gives me little nuggets to work on so that I can prevent my brain rot from becoming fatal.

Labels: , , , , ,

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home