The backup file contains the system objects, and then all the data in your database, but it contains a portion of the log as well. Any changes that were done...

The backup database doesn't affect the log. The backup log will clear out the changes in the log and allow that space to be reused.

As mentioned, you should be fine with just sending over log backups after the full is moved.

If you lose a log backup file, then you will need to send another...

Third party tools make this easy, and if you do it much, or you have issues, they might be worth looking at.

DTS, the wizard, might be the easiest way to...

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...