You can build your own auto-failover mechanism with a job on the mirror server that connects to the primary database (via linked server) and drops mirroring / recovers the database...

One thing I haven't seen mentioned is to ensure that your indexes are not fragmented and your stats are up to date ... rebuild at least the stats nightly if...

I would think you could do something with linked servers and the client-side redirect abilities in the sql native client so that it would automatically redirect to the new principal...

Grant Fritchey (9/8/2008)

---

Our servers only restart once a year as part of the annual power down (although, some of them do, occasionally get rebooted for other reasons :sick: ). I...

You need to restart the agent for it to take effect. If it still isn't working then try removing dbmail from the agent, restarting, adding it back and restarting...

Also be aware that it won't connect to SSIS 2005.

I would think your best bet for minimal problems would be to set up another instance on that server using the binary collation, server resource permitting of course.

The wikipedia entry gives all the command line options : http://en.wikipedia.org/wiki/Robocopy

The basic syntax is along these lines: robocopy C:\source C:\target /M /E (where the /M option copies only the files...

You could just use Robocopy or similar, very easy to set up so that only files with the archive flag set are copied (and then unflagged). You could run...

Ha, I am the admin!

No, they aren't being filtered in any way, and this is across 2 emails with different providers. Sometimes I get the daily email, sometimes (including...

Every case, and business, will differ to some extent but the common items mentioned above (backups, restore, monitoring, security etc) will apply to EVERY database so I would consider them...

I get my topic replies but very rarely get the daily email or database weekly. I even changed email addresses to see if it was a problem on my...

From memory I think there is also a requirement to use the semicolon between some of the service broker statements and in some of the new 2008 functionality, I'd have...

I tend not to use them for aesthetic reasons as much as anything. I do put the semicolon after every statement now though .... it is mandatory with some...

It's also possible to assign an IP address directly but you have to use TSQL as SSMS will validate the value in the mirroring window (giving the FQDN error).