parents came over here from what used to be the USSR almost 30 years ago. dad got a logistics job and my mom had to learn english and went to...

how do you do it?

i run Evault backup software for SQL backups and just set a schedule for full and log backups. you can do this with veritas and any other backup software

we have a script that uses sysprocesses to look for blocking spids. runs every 2 minutes. on a few servers i want to rewrite it to use the requests dmv.

in...

if you reboot a node it will automaticaly fail the instance over to the other cluster node, etc

did something similar a few months ago with the connections and sessions DMV's. it was very nice except took a lot of storage. if we did this on a regular...

http://www.bookpool.com/sm/047019135X

if you are in the northeast, check out bookpool. cheaper than amazon

you can detach and reattach without a log file and it will make a new one. instructions are in BOL

i had to do this on a small database last week

run an insert for each table where the PK is not in the dest db

insert new_db_tablea

select * from old_db_tablea where...

get a weblogic server or MS Access

every time you kill them, they come back

check out the one from Wrox

test your applications in QA

if you can do a side by side upgrade with new server name, etc. easier to roll back if need be

we use Veritas and Evault for backups and it's cluster aware

if you have a corrupt log file you can attach it and create a new log. if it's a corrupt mdf file then you need to restore

there was an article in CIO magazine a few years back about how AT&T tried to implement a new CRM system and it was a total failure

CRM/ERM apps are...