All I can add it "Allen is the man!"

That's strange. Are you sure that the rights cover those files? Perhaps there's something weird with them?

Can you log in as the domain user running the Agent?

The user must not have rights. Access denied is a simple message. Do you have a domain user running the Agent? Can you log in as this user and execute...

I pinged my resident PS expert with this thread, so hopefully Mr. White will respond.

I'd agree that you need two roles.

Create a role in each db, then assign the permissions needed with the GRANT statement. If you don't grant rights, as in control of...

Are there connections open by any chance?

Linked servers?

http://msdn.microsoft.com/en-us/library/cc281962.aspx

The issue, in my mind, is that even if this is fixed, a rouge administrator can use tools to crack these password hashes relatively easily and impersonate someone. So this...

The rights are those of the job, or agent, running the job. Not the user that runs the job. You can specify a proxy account for SQL Agent, but if...

You can shutdown SQL Server from within SSMS using SHUTDOWN as a T-SQL command. (http://msdn.microsoft.com/en-us/library/ms188767.aspx)

I almost never restart my servers from the command prompt. The GUI works fine, and will...

We hope you get our newsletter, as we run new articles every day, as well as getting them from around the Internet.

For SSIS, you might check out SQLIS.com, though I...

I'm not sure what is being asked.

Do you mean, paulj_p4, that you want a compound key, meaning that companyID becomes part of every primary key, as Barry mentioned? Or do...

You should not need to disable the log backup.

I think for #2, he means a RESTORE command as the query. It's not a query per se, but a batch command.

FAQ is a good idea. I'll start looking at a set of pages for that.

Paul, I'd raise this issue again, and actually I'll make a note of it. They do update things, but it's a big book. I'm not surprised things fall through the...