Awesome, thanks for sharing your solution!

Take a look at this article[/url]. Though he doesn't say it, the @WindowsUsersAndGroupsInSysadminRole he talks about is in the Server Installation Settings facet. (Of course ;-))

Please take a look at this thread by someone else facing the same issue.

If you haven't already, take a look at this page, it deals with possible causes for the 1418 error.

I don't know of any inherent problems mirroring between 32-...

So, you're able to issue the SET PARTNER command on the mirror, but when you try to issue the SET PARTNER on the primary you get the 1418 error?

Can you post the results of this query, please?

select * FROM sys.dm_os_performance_counters WHERE object_name like '%Memory Manager%'

But to address the syntax error, you have an open parentheses with no matching close parentheses.

You're welcome. 🙂

No. I'm not sure how you get output from a task in the maintenance plan itself to go to a file.

What I was referring to is the job that...

Ignore it. The Queue Reader job must already exist on this instance. You only need one.

There might be a better way, but what initially comes to mind is to put this script into a separate step in your backup/maintenance job. In the Advanced tab...

Assuming you're restoring back to the same datafile location(s), it's fairly straightforward. Below is the code to script the restore for the current database. You could easily modify...

Are any of the values you're using to calculate the @RunningTotal NULL?

Is the new server the same build as the existing server? If it isn't you may have trouble, according to this.

If they are the same, shouldn't you be able...

Found it! From this very informative article, Understanding SQL Server Memory Grant:

"The server calculates the memory limit for one query. By default, this is 25% (20% on 32bit SQL...