Can I install the 9.0.3054 fix without installing the patches before it (I am on SP2)?

thanks... I got another question. If I want to go back to the previous build after I install a service pack how can I do that? (I don't need to...

yep .. I know - I don't have the resources to use a witness. thanks anyway 🙂

just another question. If you are using multiple principals pointing to the same mirror...

thanks Steve

I just thought of something. Lets say the power supply died on your principal (or some other serious hardware fault that prevent the principal from booting. Is there any...

I have 16 GB of RAM on SQL 2005 64 bit. I think my max memory setting were wrong cos paging is crazy.

if that is the exact values for the bales then they it looks to me you could use a union query for the 3 results (each result relates to a...

I spoke to a few people about remving the page file. We agreed it was probably not the best due to not being able to check memory if the...

never mind.. I found that it meant CPU's

I am tending to side with Marcus about removing the page file because. When this happens (the paging) there is still plenty of RAM avialable (several GB) and I have...

I was wrong the edition is standard for the instances. Is there any advice dealing with paging with this?

thanks for your assistance Gail.

All the instances are using the same service account - svc_sqlserver which has the lock pages priviledge. RSOP is not registering this GPO as being...

rebooting was no good - seems to not want to apply the lock pages in memory GPO as it doesn't register in RSOP or sql server logs.

the instances are all...

thanks Marcus.. you are probably right about the 10 instances.. but I am not convinced that this is the problem in this case because I turned off the services...

thank you - I would not have done that if you didn't tell me 🙂

that ok .. I plan on using manual failover anyway.