This is the error I get.

Msg 156, Level 15, State 1, Procedure MyProc, Line 13

Incorrect syntax near the keyword 'union'.

Thanks for the update!

If you just need to know if a database has been accessed and not anything specific about the users connection, you could probably just use sys.dm_db_index_usage_stats.

Though going back to the...

Sounds like a good use case for a logon trigger.

http://technet.microsoft.com/en-us/library/bb326598.aspx

I know this is an old thread, but it's an interesting topic to me.

If you're still around I'd love to hear more of the story. Or if...

On the cheap I'd suggest running any old multicore desktop with a big usb hub that you can present as various drives, with as much cheap ram as you can...

What kind of SLA do you have for RTO and RPO? What kind of data loss is acceptable?

Any budget for virtualization?

How do your app servers connect to the databases?...

Sounds like you have a couple of questions bundled in there. But to your main point yes, you should be able to use a DNS alias to point to...

Depends on the type of disaster you are testing for, and what the DBA role means to your organization.

Here are some of the things I'd look at.

What do your typical performance and counters look like?

What's the target server memory, and total server memory under the sql...

How are you adjusting the memory the server has?

[font="Arial"]I adopted a legacy log shipping setup that was sent over sftp using a combination of SSIS, putty, Sqb2mtf, a series of stored procs, and several configuration/logging tables.

It was mostly...

There are...

Couple of things you may want to look at. First is how the licensing on your VM software works out with the change in ram allocation. Second is...

If you do that you will lose any existing report and data source on the new server. If you are fine with that, then yea that should work, it's...