This LUN extend capabilities may depend on the kind of san you have.

HP xyz ?

A "strange" consideration.

In my test without a witness, but synchronized, it I simulated a principal failure (by shutting down its instance (instance01) ), I needed to perform

a Alter...

If - as you say - you suspect the mp:

- inspect the mp logging files (activate if needed)

- start a profiler trace right befor the mp is scheduled to launch.

-...

did you check the post sp4 hotfixes ? http://support.microsoft.com/kb/894905

e.g. http://support.microsoft.com/kb/902851/

what version of sql2000 are you running ?

(+ sp / hf)

Yep, coffee did the trick :w00t:

Oh I'm sorry. :blush:

I've forgotten to remove the quoted section.

I started with a quoted reply, but just wanted to add to your arguments.

AndyD (6/20/2008)

---

When the link between Pune and Mumbai goes down, do users update both databases (Pune users update their local DB, and Mumbai users update their local DB)?

If yes, then...

For mirroring you need to test network speed, if you want it the synchronous way.

Even assync your transaction load will need to meet the timeoutcriteria to couver the 100mi within...

technet.microsoft.com/en-us/sysinternals/bb896655.aspx

you can download it free.

You can find operation / parameter information at the webpage.

read Jeff Modens article on "tally table"

Script the whole DDL using SSMS.

Keep in mind to adjust all the scripting parameters you need !

Rightclick on a dabase name in the object browser, choose tasks and go from...

get sysinternals handle to find out what other thing is holding your file.

I think you have an operator percedence problem: Your ORs stand on their own, neglecting the other predicates.

WHERE (c.CustomerID = '3942')

AND (ol.DetailTableID ...

- Nice intro to SMO for this purpose.

- Keep in mind, you have to inspect the .bak files content. They may contain more than one backup.

- You can even perform...