The error's pretty clear.

You're telling the optimiser to use a particular index that it absolutely cannot use to run...

What do you get when you do a syntax check on it. Exact error please.

As an aside, I see lots of nolock. Do you know what that really does? See...

The error message explicitly states that you cannot assign a permission to yourself. If you're logged in as a particular user you cannot grant a permission to that user. Furthermore,...

How are you doing the backup? What's the 'insertion process' actually doing? What's the error that you're getting?

You mean an index hint "WITH (INDEX = ...)"?

If so, you do it in an inner join the same way as your example. The hint immediately follows the table.

That said,...

Is the drive there and is it accessible through Windows?

Does the SQL service account have sufficient permissions to write backups to that drive?

Are you currently logged in as 'User'? Is the table owned by 'User'?

Are those logins correctly mapped to the users in the database?

If you just created new logins on the server it's highly unlikely that they won't be. Look up 'orphaned users'...

Sorry, I don't understand your question. Can you explain in more detail please? Possibly include the queries and table/index definitions?

Is the drive still there? (is it accessible through windows)

Is it a clustered SQL Server instance?

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic836978-150-1.aspx

How exactly are you trying to grant permission? What's the script?

You don't need to explicitly grant permissions to a database owner or sysadmin. By default they have full rights to...

Ivanna Noh (12/20/2009)

---

jI have no idea what would be using the log file in the middle of the night - certainly no other scheduled jobs. The database is mirrorred so...

mike_walsh (12/20/2009)

---

My add-on thought to the idea that Aaron and Brent came up with is to tweet questions from RSS feeds from forums like this and sites like StackOverflow/ServerFault/MSDN Forums/etc....