Sure..Thanks..

Let me put it this way:

Say...

GilaMonster (3/6/2012)

---

Your autogrow is too large for the disk subsystem to complete. As the error says: "Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to...

MyDoggieJessie (1/11/2012)

---

Please be more specific:

1) What's an "acceptable" amount of lost data? i.e. Anything since the last full backup? 2 hours of data? 6 hour? NONE?

2) What...

The DR should be up within 24 hours after the disaster...

Dev (1/5/2012)

---

itsamarnath (1/5/2012)

---

Dev (1/5/2012)

---

Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify...

Dev (1/5/2012)

---

Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server...

Can somebody help us here:crying:

3 databases are in mirroring.

And every time these errors are logged, the website which is using this sql instance goes down and sql becomes unreachable..Finally, we are actually restarting the...

yeah Its running.

So, to summarize the discussion, if MSDTC is running in each and every node, it can handle the distributed transactions on the instance running...

Thanks..Now the basic question..

How would I find out if MSDTC is locally enabled on those nodes?

I do not find it in the add/remove programs either?

Elliott Whitlow (12/7/2011)

---

In SQL 2008 MSDTC no longer must be clustered, but I am 99% sure that it is running on the existing nodes that the first instance can run...

Thanks All..am done with the setup

How would I ensure that My installation doesn't go to C Drive but I want to put it on D Drive?

I got the error message that sql server 2008 R2 setup required .net framework 3.5 SP1 to be installed?

what am I suppose to do here?

I see that .net framework 4...