To make sure I understand, you are mirroring a database between two instances on the same server?

How are you simulating the failure of the principal database?

Make your meetings stand up meetings. No one sits. You will see how quickly people want to get through the meeting.

I'm going to point you to Books Online. Much of the information you need is located there. I'd have to do some research there myself to answer your question...

Nataraja Sidgal (2/9/2012)

---

Change the recovery model from simple to full or full to simple - this will reset all the bitmaps.

Then perform a full backup. Set the database to...

After a reread, you are looking for a query that will return the customers that have purchased both "offer1' and 'offer2' and each of these are represented as individual rows...

Change the AND to an OR and give that a try.

It is interesting that the process fails, unfortunately not much we can do with that since we can't see from here what you see there. Could you provide us...

Now that it is officially posted on facebook, I can start telling everyone.

Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was born at 11:10 (German...

I'm still waiting for the information I requested from you a few posts back. I thought I was pretty specific about what was needed.

I'm not going to try and guess...

We can't help you if you don't help uis by providing us with the information we have requested....

What is missing are concrete examples of what you are trying to accomplish. Please provide us with the ddl (CREATE TABLE statements) for the tables, sample data (as a...

A user with ALTER TRACE permission can also use the WITH LOG.

Did you really post your sa password on a public forum? If so, you need to change it now.

What? You were gone and we missed having a...

jcrawf02 (1/26/2012)

---

Lynn Pettis (1/26/2012)

---

I had a 1990 Ford Festiva. It was a trooper, went 30,000 miles without an oil change once. First mechanical work (right front toe arm) at...