Quick follow up. I got this from my ISP:

"I would suggest using SQL 2008 - this gives you a tool called resource governor - this allows you to create groups...

santhu (2/3/2009)

---

Job History shows that "Failed to Notify Operator via mail"Error Log

Error log shows the following error message.

[264] An attempt was made to send an email when no email...

Thanks for the reply.

If the stand by server is read only then I dont think its an option for us. Our incoming data needs to read/insert in order to...

thanks again for the reply.

So whats the difference between LOG SHIPPING and TRANSACTIONAL REPLICATION then if both use the transaction log to keep the second database up to date ?

Both...

GSquared (2/2/2009)

---

Planning this kind of thing isn't an easy task.

Rather than worrying about a single database being a single-point-of-failure (where if it goes down, the whole thing is down), you...

thank you for the reply.

One additional point. The database needs to be highly available otherwise it creates a bottleneck for our nodes. The bigger the DB we are finding the...