We ended up with a corupt msdb after a power outage. Restored the msdb backup, and noticed that emails were not going out after jobs completed. Went into...

Add me to the list. What is the best protection, and how much (approximately) of a performance hit are we looking at?

I think each time someone types "architecting" in an article they should have to write on a blackboard 100 times "architecting something is the same thing as designing something but...

My company writes software that is "off the shelf" meaning we try hard not to customizations for each user, but is very industry specific. We've been asked this question...

Mirroring more databases is not a problem. We mirror almost 200 from one server to another, you simply run out of worker threads if you don't change the defaults....

I have not tried out your script, but I certainly like the concept. We mirror for disaster recovery purposes across the internet, and I don't like to build up...

Thanks for the initial insight S-M.

I should point out that it IS working, just not as well as I would like. In particular I don't like the 80% of...

I'll just speak up for the contrary argument (most DBAs are in favor of advancing the "hand off the path" method and keeping the blobs out of the database). ...

Log backups on the principle, once database mirroring setup is complete and running, whether or not at the mirroring is 100% synchronized at the moment the backup is taken, have...

If you simply use DBCC ShrinkFile on the principle's log file, the resulting change will be applied to the mirror as well in a very small transaction. The mirror...

Just to add in some details - No need to break mirroring, do anything special on the mirror.

If you simply use DBCC ShrinkFile on the principle's log file, the resulting...

I belive MS suggests that the primary and the mirror have identical drive mappings for reasons like this. Yes, adding a file on the primary will transfer to the...

We mirror our customer's hosted databases in high performance mode. About 140 databases, from one server to a twin located on the same network switch. The purpose is...

I had similar fears about the failover. We went with NO automatic failover, and thus, no witness server. We wanted a very near real time backup, and the...

We are using the Mirroring feature to provide a "very warm" backup for 149 (at last count) databases. We have two identical machines, and use the high performance (not...