Does another user have the file open on their desktop?

Surprisingly, we have more important things. I noticed it and a few people have pointed it out, but there's not really any other choice that makes sense, so hopefully it's...

I see the article. What browser are you using? Do you see what's attached below?

You want this stuff written to the log. It is how you can ensure that there are no integrity issues, like if the power dropped in the middle of your...

I haven't. HAve you checked the security on the files created each way?

I think I noticed #2 as a bug. The task actually builds the code at runtime and if you delete the databases, you can't undo this. I believe you need...

I should have remembered that. Good idea, George!

If you are planning on using SQL Mail, I'm not sure the transaction log comes into effect. The log is used to record changes to data, not mailings, alerts, or...

The job doesn't contain the steps for the plan. The job just runs a "package" that's set up with the plan. The job is just a trigger for the maintenance...

Thanks for the update.

Is this strictly a security issue? I'm wondering why someone can be a sysadmin in one db and not another? Are you a sysadmin in the other...

Antares is right in that you can't determine this after the fact.

You can set up a trace for logins and just track this over time. If you only get logins,...

Keep in mind a couple facts. Jobs aren't re-entrant, so if two people do this and the job is running for the backup, the second person might not get their...

The issues with the ZIP file were the editor's (my) fault. They have been corrected and my apologies.

Do you mean you're taking a full backup or creating a database snapshot? I assume the former as there is no "snapshot backup".

Is there a particular period of time or...

You can also potentially move all the objects from the NDF into the MDF and then remove the NDF from the database. You can move tables by moving the clustered...