Yes, you can use mirroring and clustering together, but there is an important adjustment you need to make. Take a look at my blog entry on this topic: http://www.sqlservercentral.com/blogs/robert_davis/archive/2009/02/23/What-would-be-the-best-practice-to-configure-Failover-Clustering-and-Database-Mirroring.aspx

Hi, I've covered this on my blog: http://www.sqlservercentral.com/blogs/robert_davis/archive/2009/02/22/Will-the-Mirror-automatically-fail-back-to-the-original-Principal-when-it-comes-back-online.aspx

Grant Fritchey (2/20/2009)

---

I'm a little surprised at the "it's not DBA specific" statements. For those who don't know, yes, this site is focused on SQL Server, but it's not a...

I would agree that Log Parser is a very useful tool for DBA's. It gives us the ability to directly query log files, and it also imports log files into...

I agree completely. It's a great article for Firefox enthusiasts, but it offers...

Sounds like it isn't able to get the IP address for the server. Check out this KB article: http://support.microsoft.com/Default.aspx?kbid=940254

Jay, can you provide a little more information?

Are you using 3 separate servers or are any of the instances shared? If shared, are the shared instances using different ports for...

Great article Gail!!! I'd love to see a follow-up where you measure the effects that snapshots on a mirrored database (on the mirror partner) running in synchronous mode has on...

matt stockham (9/24/2008)

---

Re. inserts ... wouldn't it have to write an entire page of null bytes, so still the same data size?

Logically it shouldn't need to do anything...

Unless the database is very small, this script will blow up the tran log.

Things I would change or add to this script:

1. Abort the script if the specified/current database is...

Thanks for the comments!! The UDF wasn't intended to be an all encompassing way to determine if a number could be converted to int. The UDF was merely a way...

I have to agree with the others. I think blaming SQL Server because someone doesn't code something correctly is just plain illogical. Using that logic, every mistake I ever made...

Not really off topic, but I attended SQL-Fest (a Microsoft event) and there was an excellent segment on how to deal with very large databases in a dta warehouse by...

But do you realize that your statement hurts performance of the query?

This part: @dtRpt BETWEEN dtFrom and COALESCE(dtTo, GETDATE())

In order to perform that query, SQL has to scan the entire...

No, but they should. If you...