I've not had to renew anually, so a one off deal I would say.

I would use a completely different server as the distributor, it offloads all the work to that server, easing up the load on the other two.

As for the snapshot, you...

Before going to the extreme of REPAIR_ALLOW_DATA_LOSS I would try a couple of things. Firstly drop and recreate all the indexes on the table. If this doesn't work, drop the...

The first one works like a charm however.

I've changed the int to a bigint (as it's storing the date a milliseconds since 1970).

Thanks Frank

The second one converts the literal string into the binary value before returning it as an integer.

Dong, you can set up certain RAID levels within Windows, however this has an extremely high performance overhead which, in most cases, negates the point of having RAID in the...

If you can afford a SAN it's the way to go.

Otherwise, go for the external array for your user db, keep the system on internal RAID10 (personal preference again).

You could alternatively run it on a different server, or through the Windows Task Scheduler.

I personally prefere RAID10 across the board, but that's just me.

Unfortunately stuck with RAID5 and nothing I can do about it

Randy, cluster admin rules. Honestly. It handles everything in the failover for you, fully automated.

You'll set up the disk on the array so that it can be seen by both...

Wish I could take the credit for the idea, but someone else in the forums gave it to me....here's the code that I use... I am using a proc usp_sendmail...

The problem is that with over 135 jobs it's a nightmare logistically.

As Shane says, you've got an external RAID Array there, rather than a NAS. External RAIDs perform great, depending on the setup, and I've found are second in performance only...

Can you not use the ADIS objects to query Active Directory?

Paul,

you could also add a trigger to the sysjobhistory table to email when a job fails. This negates you having to micromanage the job failures notifications.

I do this and include...