MysteryJimbo (4/20/2012)

---

liteswitch (4/20/2012)

---

Thanks for the responses. And yes, just to clarify, my requirement would be to have both clusters available for read/write operations simultaneously, with the write operations synchronised between...

"Error: 18456, Severity: 14, State: 58. Login failed for user ''. Reason: an attempt to login using SQL autentication failed. Server is configured for windows autentication only. [CLIENT: <local machine>]"

Yes,...

vinu512 (4/17/2012)

---

What do you mean by BLOCKING?

According to Microsoft the following is BLOCKING:

Blocking

Is that what you mean??...

Anyways you can get the Database back to that state if you have a...

Lynn Pettis (4/16/2012)

---

SQLCrazyCertified (4/16/2012)

---

Mike John (4/14/2012)

---

If a column is defined as a primary key, then by definition it cannot be null, so you cannot do anything to allow nulls in...

Mike John (4/14/2012)

---

If a column is defined as a primary key, then by definition it cannot be null, so you cannot do anything to allow nulls in there.

It can...

Thanks Lynn for your quick reply. 🙂

Regards,

TA:

jralston88 (4/13/2012)

---

We have multiple instances of SQL Server 2000, 2005 and 2008.

We want to test our restore process for each database. Since we don't want to test on our...

aliraj0 (4/14/2012)

---

Thanks to all of you... Your ideas helped me a lot...

actually i need the same database to be on both main branch and in sub branches..

for example...

aliraj0 (4/13/2012)

---

I NEED YOU HELP

ANY IDEA ANY SOLUTION

SCENARIO:

An organization suppose Jason industries have its branches in different regions of country. In each branch there is a local database where they...

Larry Page(Ehs_Akb) (4/13/2012)

---

SQLCrazyCertified (4/13/2012)

---

Larry, Whichs edition are you using?.....if it's enterprise...

Larry, Whichs edition are you using?.....if it's enterprise then you are...

Henrico Bekker (4/13/2012)

---

If you have enough disks, best setup would be:

Sys db's on own disk, but have tempdb on its own drive.

user db's on own disk.

split mdf and ldf's...

Well, it...

SQLKnowItAll (4/11/2012)

---

In mirroring, the data is not "restored." It is synchronously applied to both the primary and secondary server so that the data is always in sync. Failover happens when...

I beleive in 2005, 2008 and 2008R2, you can read from mirror DB by doing a snapshot of mirror. Your thoughts.