I had similar fears about the failover. We went with NO automatic failover, and thus, no witness server. We wanted a very near real time backup, and the...

We are using the Mirroring feature to provide a "very warm" backup for 149 (at last count) databases. We have two identical machines, and use the high performance (not...

Can you tell us anything else about it? Is it a USB drive, firewire, or a normal...

Steve Jones - Editor (6/1/2009)

---

Not sure that z: is a network drive. We standardized on z: for our servers years ago as the data drive for local storage. That way...

rambilla4 (5/30/2009)

---

thank you,

Iam restoring from the local drive only.

In Server A (Development Server), is taking 20 mins, which is a Virtual server having Backfile and datafiles on same drive...

Dammit. This is of course the first thing I read when I opened up my email, so I didn't even have the April 1st context in my head yet....

After a read, a re-read, and digesting the posts before mine, I've come to the conclusion that the best concept in the discussion is using a pull based method to...

GilaMonster (3/4/2009)

---

Yup, list all the column names (as you've done in your example)

If you don't want to type, and I don't blame you, then there's a quick way. Expand out...

The basic point in my mind is that unions try to make everyone "above average". The best of us would see our benefits and pay go down, the worst...

We are 100% on SQL Server 2005. We moved from 7 to 2005 to get the 64 bit version and far better memory management and user capacity with new...

Dear Learned Ones:

I need help with a SQL Server problem. I don't understand exactly what's going on, or what I should be expecting, but my co-worker said I should...

Well, first and foremost in my opinion, turn OFF Automatic Updates. Use the "download, but let me choose when" option so you can:

a) See what you are going...

I'd set the max on each instance to total up to about 2.5 gig less than the total RAM installed. On our 64 bit servers, (single instance) it seems...

I can't tell you "how long it will take" to write to the secondary server without a LOT of details. Nobody can. But I CAN tell you this:...

With regards to mirroring:

High Availability is "synched writes". The user's change is written to the primary server. The primary notifies the secondary. The secondary also does the...