If i recall you have to take the cluster offline and start sqlserver locally to make the change. The problem is when you failover the change won't go along with...

current settings are allow inbound and outbound .. is this incorrect?

That was something I thought of too; ensure you CYA and tell the powers at be that in order to do the maintenance you may expose them to more data...

take a read through this article.

[/url]

ouch. Performance won't be the best, but do what you can with the other indexes and keeping stats up to date.

You are up against a wall on this. You will need more storage to accomplish the task. Which will require an outage to move the log to.

also: No downtime at...

Is there another drive with more space that you could move the log to?

It sounds right to me, but I'd wait to hear another opinion. I have only done it twice

One thing I would do is allow the transaction log to grow.

Lavanyasri (8/5/2011)

---

Thanks Gila,

You are right. Data is very important.

The main reason why my database goes to suspect mode is server restarted 2 times . Paricular database goes...

It isn't really a true Active/Active as one instance isn't aware of the other. Its more like dual Active/Passive. But it is as logical as you stated

Node1

1) New SQL Server...

mike.mcquillan (6/29/2011)

---

I want to back up BitBucket. We all make mistakes - and let's face it, if it wasn't for Steve and a couple of others this site would not...

it is always there

one thing you could try would be profiling a standard trace then taking the profile and dropping it into a table then delete the stuff you don't want or need....

SQLRNNR (6/8/2011)

---

crashdan (6/8/2011)

---

The db would be in restore mode in this case, so not able to be accessed the same...