Archive for the ‘T-SQL’ Category
RYO Maintenance Plan – Enhancement Request
In response to my last post, I got a very interesting comment from Philip: “I would love to see a way to add logic that will verify at least X backup files for a given DB remain. Specifically, in my organization, I would like to delete all but the most recent one– even if that [...]
February 9, 2012
Tags: database maintenance, scripts, SQL Server Posted in: Maintenance, T-SQL 
No Comments
RYO Maintenance Plan – Database Backups, Part 3
I’ve covered creating my backup directories and the actual backup of the database(s). The last thing I want to do in my process is clean up any old backup files. Once again, I want to allow for some flexibility in my procedure. Much like the maintenance plan task I’m replacing, my procedure should be able [...]
February 6, 2012
Tags: backups, database maintenance, scripts, SQL Server Posted in: Maintenance, T-SQL 5 Comments
RYO Maintenance Plan – Database Backups, Part 2
Last time I dealt with the creation of subdirectories, in one or more root locations, to house my database backups. Today we’ll get into the meat of the database backup procedure itself. If you’ll recall, this procedure has to meet some specific criteria: It will need a minimum of tweaking to implement and maintain. It [...]
January 30, 2012
Tags: backups, database maintenance, scripts, SQL Server Posted in: Maintenance, T-SQL 4 Comments
RYO Maintenance Plan – Database Backups
Anyone who knows me knows that I’m a big proponent of automating routine tasks. If I have to do something more than twice, it should be scripted (if not fully automated). I’ve also made it fairly clear that I’m no fan of SSIS. So with all that in mind, it should be no surprise when [...]
January 23, 2012
Tags: backups, database maintenance, scripts, SQL Server Posted in: Maintenance, T-SQL 6 Comments
TSQL Tuesday #026 – Second Chances
Welcome to the first TSQL Tuesday of 2012! This month’s soiree is being hosted by Dave Howard (blog | twitter) and he’s feeling a bit nostalgic. As a result, we get to pick from any of the previous TSQL Tuesday topics and write about that. He’s even included a handy list to choose from. You [...]
January 10, 2012
Tags: #TSQL2sDay, SQL Server Posted in: Professional Development, T-SQL 3 Comments
