Programmer's Edge

In a lot of instances, you may be doing something like database mirroring or a migration job that involves a lot of databases and possibly a lot of backup files, especially transaction log backups. It’s a real pain if you have to restore these files by hand. It would be much easier if you have a way to get a listing of all of the backup files for a particular set of databases so that you could write some code to quickly produce a script to do them all at once for you.

Luckily, SQL Server maintains such a log between the two tables in the msdb database: Backupset & BackupmediaFamily

A simple piece of T-SQL code can then be used to return the information on the all the backup ran for that particular instance. Then it is just a matter of wrapping this knowledge up in a process to output the appropriate script for the particular restore process that you are needing to do.

Below is a sample T-SQL query that can be used on both SQL Server 2005 and SQL Server 2008:

SELECT database_name
       ,user_name as ExecutedByUser
       ,physical_device_name
       ,backup_finish_date
FROM msdb..backupset bckupset
     INNER JOIN msdb..backupmediafamily bckmedia
     ON bckupset.media_set_id = bckmedia.media_set_id

Cheers,AJ

Better late than never. Here are the slides for the Ft. Wayne PASS group presentation on Building ETL Processes with SQL Server Integration Services(SSIS). It is definitely a hot topic of interest in a lot of the SQL Server 2005 and SQL Server 2008 presentations that I give as it still seems that some people have not really come to fully utilize the technology yet. The group was great and I would encourage anyone whom is in that area to swing on by!

Ft. Wayne Pass Group Website

Presentation

Cheers,
AJ

Here are the slides and demos from the Eli-Lilly Lunch & Learn presentation that I gave a few weeks ago(thanks again Google).

For those of you in attendence this consists of the slides and also the code examples that I talked about giving you. These should allow you to get well on your way to being able to leverage SMO within your environement.

Enjoy!

SMO: Lunch and Learn Files

Cheers!
AJ

Well, the 1^st annual Rocky Mountain Tech Tri-Fecta has come and gone. It was a blast from beginning to end. The pre-event was a lot of fun as my group really killed Scott Hanselman’s group at bowling.

Thanks to Julie for coordinating a great event as everything went off without too many hitches. I was lucky enough to be able to give 4 presentations during the day( 1 due to a cancellation) which were all a real blast. One guy actually said he was going to recommend me for an MVP..LOL. Hopefully, he is in tight with Bill and Melinda….

So for all those people whom wanted the slides and demos….(remember SMOoggle is already Trademarked and Copyrighted )..here they all are convienently zipped up in a single package.

Rocky Mountain Stuff

Cheers,
Aj

Good Afternoon, from Miami. Things are popping here with several hundred developers/DBAs roaming around here. As promised here are my presentation slides and examples from my first talk of the day on SMO. Included are the coding examples for the SMOoggle example and the Security Checker.

Please note the disclaimer below:

AJ Disclaimer: These code examples are being provided for example only and should not be considered a production ready application. They are merely an attempt to demonstrate some of the cool things that can be accomplished using SMO. Please do not expect any support as such. Of course, all work is strictly copyrighted and tradedmarked and all that jazz. So don’t let me catch you trying to release a corporate version of SMOoggle without my permission.

Presentation Material

Cheers,
AJ