I launch the failover cluster manager, go to "Cluster Events", but then I see no events there: "No events were found."

How do I get the cluster log?

I'll need to check more closely how long the failover lasted; how do I do that? Get last timestamp from SQL ERRORLOG prior to the failover and first timestamp after?

Based...

Hi, thanks for responding.

In production we are running on version 10.0.2531, which is the base version of SQL 2008 SP1, ie. no hotfixes.

We had recently updated the dev environment...

I'm facing the same challenge, ie. how to best allocate resources in a new server that will be hosting both an SSAS instance and the associated relational data-warehouse db engine.

...

Yeah, I'll just have to emphasize the "your applications could break" part...

george sibbald (9/24/2010)

---

Also, remember 2008 ---> R2 is not the same as say 2005 ---> 2008. R2 is much more 2008 with extras.

Hence why the versions for SQL2008 are 10.0.nnnn...

We are using SQL Sentry, IDERA Diagnostic Manager and IGNITE Confio.

Of the 3, I'm most familiar with SQL Sentry and IGNITE. SQL Sentry has been especially valuable for us in...

george sibbald (9/23/2010)

---

Geoff A (9/22/2010)

---

SSIS running a package every x minutes will do this very well and we have used this in OLA 1 production environments for some time.

we use...

Thank you that's a good suggestion! In the current implementation I...

Geoff A (9/22/2010)

---

SSIS running a package every x minutes will do this very well and we have used this in OLA 1 production enviroments for some time.

we use the following...

Thanks...

AK1516 (9/21/2010)

---

hi folks,

We have planned for a two node fail over cluster where each nodes should have a instance of sql server 2008 running but with different database on...

BSavoie (9/18/2010)

---

Wow, this is incredibly old. I forgot the specific details of the solution. I just remember that it was related to encrypted stored procedure(s). Sombody, or something was trying...

I'm having similar issue on a SQL-2008 instance, where I have principal mirror databases, no idea what the cause is.

Yes, it's likely a browser-settings issue. I will try adding to the trusted sites.