Thank you. Good discussion started, good job.

Thank you David Bird -- it's a job well done!!

Works like a charm running against 103 active servers/1046 databases....

Looking forward to Parts 2 and 3.

Hush now!! Just keep quiet and load up your stock portfolio on all this 'cloud' hoopla!! Just remember to bail when the market figures out the whole thing...

Left out the the 3rd rule...

Hope for the best

Plan/Prepare for the worst

Always, always, always have a plan B!!!

Isn't there's also msdb.dbo.backupset.type?

Values are:

D = Database.

I = Database Differential.

L = Log.

F = File or Filegroup.

You'll have to join backupset.media_set_id with backupmediafamily.media_set_id for backupmediafamily.physical_device_name = 'YourFullBackupDirectoryAndBackupName'

Right?

I agree with blandry. As a contractor I've seen the gamut, clients still supporting 6.5 and running Windows 2000 to those running Windows 7, Server 2008 and SQL 2008...

Thank you JeremyE!! That white paper didn't turn up in my search. Really appreciate the link!

Gary

I wouldn't have posted the question without having been there first. The links I found didn't really amount to much. Maybe it's time for me to write an...

just call me Rev. Gary from the church of No Cursors!!

Cursor? Never!! Okay, maybe at gun point... just maybe... it better be a big gun... 😎

Derrick,

Thank you!! I didn't know it could do that!! A thing of beauty!!

Thank you all for the ideas!! The wheels are turning now!!

Gary

Some readers but no replies...

How about this...

1. Get an 2TB eSATA II hdd and cable for about $250

2. Full backup at DataCenter to new hdd

...

Thanks Gaby -- and thanks to all who added their replies... lots of good ideas have been shared. I'll mark this one as a keeper!

Not exactly but you were close so you win the cigar and a big brewski!!! Buried under C:\Documents and Settings\user\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\ is a litle file named RegSrvr.xml

You...