And sql-performance.com is available for $19 from NetworkSolutions. If anyone buys it, please forward a $1500 finders feed to me.

We do this all the time from IIS jobs and it works. What is the circumstances you are running when it fails, e.g. what is different?

You can script it outside SQL also, but just another thought -- look into log shipping. Then the file can be restored automatically from only the changes being sent...

Thanks. I appreciate the feedback and Education. Can I get more?

I'd welcome your advice on our setup if interested, and maybe the discussion will have interest for Bradley...

(1) is yes.

(2) don't know

Big caveat -- you can't restore a log when you are reading from the database (it may be a bit more specific than that, you may...

quote:

---

If you're bottlenecked on I/O (typical of writes in an OLTP environment), then you've misconfigured something if RAID 5 is as fast...

Also interested in updates. We are going to do almost exactly the same thing.

Also, is the IIS services you are running ASP.NET based by any chance? We're wondering...

Sure. It doesn't matter what machine Query Analyzer (or Enterprise Manager) is on, so long as there is suitable network connectivity.

The only real answer is "test", but my two cents --

The biggest issue in how this works is what they are connected to. I've done a LOT of...

quote:

---

We are currently testing w2k3 with 32 gig of ram

---

Are you testing 32bit...

Re pricing, etc. -- I'm waiting on some new configuration pricing, will see how this looks then. But as to this:

quote:

---