What is the output of the following when connected directly to the server/database?

Select *

from fn_my_permissions ( '<Table Name>' , 'object')

Script out the linked server or take a screen shot of the security tab of the linked server property dialog and post it for us to see.

Also, are you using...

Richard's #3 is exactly it. How frequently are you performing log backups. It should be a minimum frequency of 30 minutes. If your server is very busy, then you should...

Yes, as far as setup goes, nothing has changed.

Yes, there were improvements in mirroring from 2k5 to 2k8.

Mirroring takes advantage of compression and the transactions are compressed before sending across the network improving throughput.

The way mirroring uses the...

If your snapshot failed, that's not the reason. You need to keep looking to determine the correct reason.

That's not an error message. Every time you create a snapshot, it has to run crash recovery on the snapshot because it may have transactions in progress when the snapshot...

Your timeout value should NOT be getting reset when the mirror fails over. What is your SQL version/build #?

You can change the timeout value in any mode, but the value...

Yes Kwilt, you'll have to set up everything for the encryption to work on the mirror as well.

I use the same method as ALZDBA; however, you should be aware that the procedures being used are not supported and are subject to change or deletion without advance notice.

The...

Agree with Cliff. Most likely you are dividing by 1000 instead 1024.

LPIM permissions wouldn't cause you to use extra memory.

You're trying to restore the database over an existing database. It appears that you are using the GUI, so in this case, you need to choose the option to overwrite...

I'm not familiar with any of the training resources mentioned. If you really want the best training available, I would keep an eye open for training opportunities from sqlskills.com (Paul...

Hopefully not complacent and comfortable.

This is the same kind of situation that prompted me to leave my first DBA position. I was DBA, lead of the database developers (which meant I was still doing...