Archive for the ‘SQL’ Category

You can find the full post here: http://dougzuck.com/hta

Sunday, August 2nd, 2009 at 16:50 | 0 comments
Tags: , ,

SQL Differential Backup Size Prediction

Sunday, August 2nd, 2009 at 16:22 | 0 comments
Categories: SQL, Technology
Tags:

You can find the full post here: http://www.dougzuck.com/hta

Saturday, July 4th, 2009 at 21:56 | 0 comments

You can find the full post here: http://www.dougzuck.com/hta

Wednesday, June 24th, 2009 at 20:46 | 0 comments
Tags: , ,

You can find the full post here: http://www.dougzuck.com/hta

Sunday, June 7th, 2009 at 23:32 | 0 comments
Tags: , ,

The MSDB database maintains a record of all SQL backup jobs that have been executed.  Specifically you can find this information if you query MSDB..backupset.  This script joins sys.databases, so that if a database exists but has not been backed up yet, it will still be displayed in the results.  If you were to query [...]

Sunday, June 7th, 2009 at 16:26 | 0 comments
Categories: SQL, Technology
Tags:
TOP