Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Maintenance Plans
Monday, February 02, 2009 9:50 AM

Check that database before you restore it...

I'm on my way to the city of Seattle this morning on the train and I ran across an issue with a database restore. I've been working with Service Broker and then put it out of my mind. I then backed up said database and restored it the same instance as
Posted by Buck Woody | 1 Comments
Tuesday, January 06, 2009 7:33 AM

Have You Backed Up Your Database Master Key?

If you have encrypted columns in a database or certificates used to create them, you need to make sure that you back up the Database Master Key as part of your maintenance, and then protect that backup file. Here's the short version of the command: BACKUP
Posted by Buck Woody | 1 Comments
Tuesday, April 01, 2008 8:57 AM

Checking Your System

In most checklists for SQL Server, including the one I explained on my last Podcast , you're told to "check your system". In fact, most instructors and DBA Experts will not look kindly on you if you don’t. But what does that mean? Well, I’ll probably
Posted by Buck Woody | 0 Comments
Thursday, January 17, 2008 9:47 AM

Controlling Just One Part of a Maintenance Plan

A few posts back I mentioned that I was speaking with someone that wanted to use the new Resource Governor feature in SQL Server 2008 to “throttle back” only one portion of a Maintenance Plan, using the Wizard to create one. The problem he had was that
Posted by Buck Woody | 1 Comments
Friday, January 04, 2008 9:10 AM

Using SSMS as a Dashboard

The other day I was asked by a friend about a recommendation on a “Dashboard” for SQL Server 2005. She wanted to be able to see all the pertinent information about her server with just a few clicks. She asked me what I had used in the past, and wanted
Posted by Buck Woody | 6 Comments
Tuesday, August 07, 2007 7:45 AM

Maintenance Plan MetaData

I was recently asked about which tables are involved in a maintenance plan in SQL Server 2005.The primary tables are: msdb.dbo.sysmaintplan_subplans msdb.dbo.sysmaintplan_log msdb.dbo.sysmaintplan_logdetail msdb.dbo.sysdbmaintplans msdb.dbo.sysdbmaintplan_jobs
Posted by Buck Woody | 1 Comments
 
Page view tracker