Thanks for the update.

Stupid GUI

Does the error come right away or is there a delay? I don't know about restores, but backups do not like network delays.

I think that will remove all databases.

AFAIK, there is no way to prevent all the databases from appearing. They are all stored in a table in SQL and SSMS reads...

My wife loved Inception, actually wanted to go see it again. I'm not a big Dicaprio fan, but I thought he was fantastic in Shutter Island. He's a good actor,...

Or ask everyone that submits a high level session to submit a beginner level one on the same topic.

You have to call Microsoft to get official support. If this is for your company, you want a legal answer.

However I think that any passive use (clustering, log shipping, etc.)...

Depends on what you are doing.

Red Gate (my employer) has done a lot of work and SQL Response 2 looks like

SQL Sentry has a performance tool that you can...

You should be able to query for those dbs that have not had a backup in xx time. Then attach that result set to an email.

Or run the query twice....

I'd be surprised if this happened. Log Shipping, as is, is a fairly simple solution, and works fine. It also gives you a delay on the secondary, which mirroring doesn't...

I'd agree with what is in the other thread. This doesn't work in SQL Server. There isn't a way to read/write to the database from two servers. Any software/solution that...

I like Lowell's advice. Set to single user, then remove.

Just so you know, I saw the judge / speedo on an episode of Justified (http://www.fxnetworks.com/shows/originals/justified/) recently. It was the first thing to pop into my head when someone mentioned...

There isn't, but a nice suggestion.

If this is for DR, you might not want to have this automated to that level. A DR server potentially will have a different name, different IP addressing, different drive...

I would second a look at replication

If you don't want that, you would have to run a script on each server to add the stored procedure. You can script that...