Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Cleveland DBA

Colleen Morrow is a Database Engineer for a software company in Westlake, Ohio. She has worked in the IT industry for 15+ years, doing everything from technical support to development to database administration on Informix, Oracle, and SQL Server platforms.

Archives: January 2012

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:

  1. It will need a minimum of…

Read more

4 comments, 865 reads

Posted in Cleveland DBA on 30 January 2012

RYO Maintenance Plan – Database Backups

Remember kids...

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… Read more

6 comments, 1,863 reads

Posted in Cleveland DBA on 23 January 2012

Goals – 6 month checkup

Last week’s resolutions post reminded me that it’s time for another status check on the goals I set for myself back in July.  Two introspective posts in a row is a bit tiresome, I know, but bear with me and this will be the last bit of navel-gazing for a… Read more

3 comments, 515 reads

Posted in Cleveland DBA on 17 January 2012

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… Read more

3 comments, 344 reads

Posted in Cleveland DBA on 10 January 2012

Msg 7395: Unable to start a nested transaction

Happy new year, SQL peeps! I hope everyone had a wonderful holiday. Last week was very quiet at work, but I did have a developer email me with a problem she was having. (I do believe she may have been the only one actually working, can you imagine??) But… Read more

3 comments, 751 reads

Posted in Cleveland DBA on 5 January 2012