I think we might get more specialized as data people, but the job isn't going away for sure.

Good comments, and I wonder how well Microsoft would enforce upgrade requirements. It will be interesting to see how this plays out and I would love to know if Energizer...

The Database Master is probably the premier one, but not many people will do that.

What are you looking to learn and where are you?

Response copied from the discussion on the backup:

Sorry, I should have clarified more how this works. This was intended to show off Copy Only backups, and not cover all aspects...

Sorry, I should have clarified more how this works. This was intended to show off Copy Only backups, and not cover all aspects of backups.

Full backups do not break the...

I'm not sure what you mean as well. This is a question since there are services and subsystems in SQL that need access to files. For example, the service account...

Well, this is my job, but when it wasn't a full-time gig, I did a mix as well. I asked me current boss when we started the site, both to...

Let's hope they don't sub it out. That would defeat some of the purpose of them using their experience.

tada - http://www.sqlservercentral.com/Forums/Topic611416-338-1.aspx

Ah, was afraid you would ask that. I'll look for it.

If you shrink the database, you almost assuredly will introduce fragmentation.

If you know you will restore this particular backup, that makes sense, but I would hope this is not a...

It does appear that it is slipping. I think with the holidays and PASS, that there hasn't been as much testing in the beta as they would like.

Still, I think...

Hey, I figured you'd check the personal one before work on vacation 😀

Glad we could help, and I'd be interested to see what you come up with, if you can share. Be sure you get permission from your boss to do so.

You have the object IDs in the error message. Use those with object_name() to find the objects and then perhaps drop and rebuild them.

I would also dig in and check...