great, bound to be a few memory leak issues with that little lot installed.

you dont...

you need to size the log file appropriately to handle transactions between backups.

what is the recovery model of the database set to at the moment?

oh dear madhu you are in a pickle arent you.

what do you have min and max memory set to on node 1?

have you thought about setting up a sql trace...

what does the following query return on the server you are having problems on?

select @@servername

it sounds as though the sql instance cannot be verified and hence it thinks no service...

have you tried opening the job remotely through SSMS on another machine?

a compatibility version of 80 doesnt mean you can restore the database back to sql2000.

as previously pointed out you would be well advised to make sure that both environments use...

interesting links, so basically if it all went horribly wrong and 1 file filled up for some reason all the data would be written to just 1 remaining data file....

Richard Hall (12/29/2008)

---

I am having this problem too, but when I go into "Lock pages in memory" in the user rights assignment, the box shows no users and the...

Steve's topic at the following link should get you started

http://www.sqlservercentral.com/articles/Administering/performancemonitoringbasiccounters/1348/

also check out Brad McGehee's topics on this subject. A google search should provide the link for that

installs as a named instance if sql is already on the machine. Re run the setup and select Analysis Services

while its true that with RAID10 a failure of a mirrored pair is terminal. Because of the amount of disks required for RAID10 its a sort of safety in numbers...

is it absolutely necessary that node 3 has 4 instances of SQL. This will affect the RAM configuration on that node

kendal.vandyke (12/28/2008)

---

Perry Whittle (12/28/2008)

---

as you say, depends if the system is already live. If...

try the following query

select @@servername, serverproperty('servername')

what is the result

as you say, depends if the system is already live. If your scoping new...