I'm a bit busy today to try to work on this, but at first glance, I think you'd need to remove the "\instancename" from the $servername variable in this line:

$Driveobject=gwmi...

Good point. Thanks!

Glad to help!

Probably not, since I don't have a setup like that that I can test with. Sorry!

The script is linked to in a zipfile at the bottom of the article. It's under the "Resources" heading and it's called DiskSpaceStats.zip.

FYI, I wrote a part 2 to...

Good point - yes that would increase the time required before a real failover occurred.

Interesting that you assumed he was reindexing the mirrored database. I assumed the opposite - that...

If it is due to the index rebuilds, you can change the length of time mirroring waits for before failing over. The default is 10 seconds. See here for info....

Or just make a maintenance plan that rebuilds them all in all databases. Schedule it for off hours though.

John__A is correct. Don't run the update stats sp after rebuilding all the indexes because you will be replacing stats that are based on a full scan with ones that...

bbsr,

Yes, you can restore a backup made on a SQL 2000 server to a SQL 2008 server. SQL will automatically convert the database to the 2008 format (rendering it impossible...

Regarding the cost issue, you will save money on hardware, but be sure you realize that SQL licenses for passive nodes in clusters are no cost.

I had to do the same thing - move logins from 2000 to 2008. Ran into some problems and it seemed to me like the issue was caused by SQL...

FYI, there is a nice routine I put on a couple of my servers that logs information like this so you don't have to worry about stuff falling out of...

Hmm. Yes, I think you did something wrong. I was in a similar situation. I had a database that had hundreds of tables replicated. The snapshot was 9 GB. I...

I wrote a blog post about this situation: http://shaunjstuart.com/archive/2010/07/hey-check-out-the-new-kid/