tcronin 95651 (6/26/2014)

---

Ok I am considering moving what is currently a win 2008 sql 2008r2 activve/passive cluster that does log shipping to two servers, one for DR, the other for...

Can you post a screen shot of the tcpip settings dialog in configuration manager

kevinsql7 (6/26/2014)

---

Thanks Hema Kuman.

I am also wondering if all three of these method (backup/restore, detach/attach, & copy database wizard) would automatically perform a database upgrade? For instance, if you are...

No problem, as i said switch to bulk logged for the rebuild and you wont break the log chain, but the rebuild will still be minimally logged

jitendra.padhiyar (6/24/2014)

---

Hello Sam,

I am able to installed DTC. It was timezone issue. I set correct time zone and it works.

Now I face new issue.. I installed MSSQL Server 2008 R2...

I'm assuming you're referring to rebuilding the clustered index that was created on the PK column?

You don't...

UconnDBA (6/26/2014)

---

As far as overlay users I mean that the source and target will have different users/permissions. If we do a backup/restore the users at the target will now...

UconnDBA (6/26/2014)

---

Looking for what others have done to keep a copy of a database, for read only, on another instance. Need to do this once a day early in...

GBeezy (6/25/2014)

---

I am somewhat of a beginner when it comes to clustering. I am learning on the job and looking into good training to speed up this process. ...

Eric Mamet (6/26/2014)

---

Perry,

This fixed the problem on my test machine.

I did not have to create an outbound rule on the client windows firewall, though.

However, there are so many rules...

What's so difficult about it?

There is...

Also be careful if using cpu affinity in the sql instance . If you apply affinity on the 80 core system and it tries to failover to less cores the...

No, it's not even remotely possible!!

Here's what you could do (and incidentally what i would...

PhilipC (6/18/2014)

---

I was just wondering what the best approach should be for shutting down an Active/Active Cluster where both nodes need to be shutdown for disk maintenance.

I was thinking of...