On W2K3, especially if everything's on one LUN (which seems to be the case .... D:?), you might benefit from using the STORPORT driver (http://www.microsoft.com/windowsserversystem/wss2003/techinfo/plandeploy/storportwp.mspx).

If you can't find...

Call me sceptical, but is this a case of the Emperor's New Cloud?

Call me cynical, but do I hear the distant scurrying of salesmen to their outsourced development departments asking...

I merely stand on the shoulders of giants: 🙂

Auto notification for failover of a server and restart of SQL Server services

That describes a solution for SLQ2K5 but the principle is...

If your objective is only to send an email alert when SQL starts, and assuming you also have SQL Server Agent set to start automatically, you could set up a...

Many thanks for the prompt response and the very informative links.

Nevertheless, just looking at the issue of how to split an existing database into several data files, am I right...

Is it possible that the Agent hasn't yet started at that point?

Assuming SQL 2000, you must already have SQL Mail set up anyway ... you also have to initiate the SQL Mail session first using xp_startmail, and terminate the session afterwards...

Having inherited a SQL 2000 database configured as single data and log files (albeit on different SAN volumes), I'm faced with the task of splitting it into multiple data and...

Ted Pin (5/15/2008)

---

satz (5/15/2008)

---

I did not think about this till now but most of the people on the motorcycle forums i visit are all IT guys. I ride with a...

I would strongly urge anyone interested in pursuing this subject further to read the book "This is your brain on music" by musician-turned-scientist Daniel Levitin (http://www.yourbrainonmusic.com/). Although a basic...

Not having the funds for musical equipment back in the 70's, I built my own guitars and amps and ended up studying electronics. With the arrival of MIDI in...

Let's take the simple case where we have a fully licensed server (OS and per-processor SQL 2000 licenses), we clone the live server onto a second identical server, and then...

Thanks, Matt. Unfortunately we will have to install SQL2K on the DR either way because the live system is tied to that version at the moment, even though only...

:laugh:

:exclamationmark: .... that's rich - unlike Windows? Note that Server Core doesn't support .NET Framework, even though SQL2K5 requires it.

Sounds like Linux ..... 🙂