sounds like the error log needs to be included in the cluster group so both servers have access to it. Did you check both nodes to see if both had...

When the cluster fails all user connections are reset while the failover happens test for connection first. Yes the transaction will be rolled back if it wasn't commited.

Wes

Exactly. I love being able to provide a total solution or outlook on a project not just software or hardware or database. I may not be the best at any...

to be honest with you it sounds like a bad scsi cable something is generating to much noise and is causing the scsi bus to loose to much information an...

Very nice read Brian. I think that virtual instances is one of the best things that they added to SQL that and indexed views.

Wes

I have used VMWare in a workstation role running on a linux box with win2k installed on it and sql server I never did any real load testing or things...

I have read several white papers that talk about SQL server not scaling well above 8 procs. With that in mind I would probably go with multi instance as well....

Make sure you have a sql group with all the apropreate services to start up in that group for failover. I'd do a look on MS technet as well. My...

Usually what I do is

Win2k adv

Win2k sp's

win2k clustering setup

mssql 7

mssql cluster

mssql sp's

I haven't had a problem with that order yet. I like to go ahead and setup the sql7...

Ok, This is what I have found so far. One, I can import from Oracle into SQL all day long. Two, using dbtools I can export from MS-SQL to MySQL...

I haven't used those products but I am a big fan of legato backup services. Can you give some details about the product and your experiences with it?

Wes

Well, I think it is a load of crap personally. I have disconnected fibre channel arrays from the server with no issues. That is a VERY poor answer. I don't...

They only own a single proc lic for sql 7 they don't wish to use it if they don't have to. I am lobbying to keep it on since we...

I've just never done it for two non-microsoft products. I'll give it a go and post some results 🙂

Wes

If it is such a small amount have you tried direct connections to the database and only logging localy if the connection isn't available? A few thousand transactions shouldn't be...