Can the user run the statement without going through the linked server? That will help rule out any issues with the linked server permissions.

If not, I would try putting...

you can try granting that login public access to the DB, and then seeing if that works...

I would also suggest that shrinking the files is a bad practice. I'm surprised Gail didn't mention that 😉

Shrinking the log for it to only grow again will cause...

How much physical memory do you have on each node of the cluster? I'm assuming they are both configured with the same amount of memory.

Instead of failing the services...

It's been my experience that small files, such as the ones you are working with, will often have fragmentation based on their size. I have tested this out by...

I don't think you'll be able to obtain the data you're looking for because SQL doesn't keep track of that out of the box. As others suggested, you'd need...

I could be wrong, but I don't think that restoring MSDB and MASTER on a new installation is recommended if it's going to be a different server name.

I would script...

Also, here is another document that I use when laying out the disks. The 80% usable column represents the max space that the DB files should use. We...

I have attached an outline that I put together for when I was performing database migrations from server to server.

The main hurdle to get over is coordination among all of...

Thanks for the reply. Your first option was the one that I figured was the likely choice, moving the tables to a new filegroup that was set up on...

Umar,

What you'll want to do is this:

1. Remove the dependencies on the disks that you moving between.

2. Remove the cluster resources from Cluster Administrator completely.

3. Re-create the cluster resource that...

To my knowledge, you can install a one-node cluster within Windows, and then add servers to the cluster as they come in.

However, I believe you will need to re-run the...

Thanks Brian. This is excellent information to have.

Thanks for the reply.

I just went through each DB on the instance and queried with the following:

select [name], suser_sname([sid])

from sys.database_principals and was able to see that the dbo owner was...

Thanks for that information. That is exactly what I was looking for. I had looked at that report but it didn't provide the size and I wasn't sure...