Nicely done, Wes! Quite informative.

Kevin Martin

Harrumph! I agree with the previous posts. A poorly designed question with no good answer.

I know it is only one point, but come on.

-km

I just started seeing this on one of my servers.  Does anyone have any ideas what would cause this?  It is occurring on a maintenance plan backup job that has...

Yes.  You can backup the Master database, but only a full backup.  You cannot do a transaction log backup on Master.

I had the some problem with the output until I commented out the line that adds the ScriptDrops option.  Once I commented that out, the output was exactly the same...

Your article mentions using log shipping as a solution for failing over to a remote location.  This was the strategy that I implemented, but after encountering a problem with log...

Nice article, but the editorial at the bottom was a bit out of place.

Thanks,

Microsoft Support said about the same thing.  I don't think they really like the idea of shipping the files across the internet.  They seem to be afraid that the files will pick...

You don't hold a grude or anything, do you?  Between Sears and Sony and who knows what other retailers/manufacturers, your list of options for...

More than likely your maintenance plan is attempting to back up the transaction log for the Master database.  Only FULL backups can be taken of Master.  Try removing Master from your maintenance plan...