why use this instead of SSMS to script everything out?

we've been doing it on a cluster for years, one of EMC's first customers to do this. works great, downside is it's only on disk level.

if you're doing physical nodes...

updatable subscriber transactional replication

i think it adds a guid column to your table so test in QA. an ex-dba did it here and it crashed the main app because it...

what do you want to archive?

it enables some columns on the sessions or connections dmv, forget which one. MS had a nice script for SQL 2005 SP1 but haven't seen anything for SP2 yet

select col1 from table2 where col1 not in (select col1 from table1)

do this for every table and i think it might work

only sure way is to test

few months back we set up a logon trigger and tested in QA first. there was a mistake in the code and we locked them...

MS supposedly changed the algorithm in the dmv to make it more accurate when it gathers the data

we don't use blades yet but OS always gets it's own RAID1 array. then separate RAID1 arrays for tempdb, logs and then RAID1 or raid5 arrays for the data

instead of a server name use an IP address

if it connects by IP then it means you have DNS issues. also try to connect using sql authentication. once in a...

i'd start by trying to ping the server, if no response then it's in the network, DNS, etc

or try to connect by IP to see if it works

we do something similar except we have a sp that goes out to every sql server and looks in msdb for anything that failed in the last 24 hours and...

is it a named instance?

sql hotfixes always apply to the instance, not the node

for windows hotfixes we just terminal server into the passive node and run WU. or if you have a WSUS server...

i run the dmv off hours and always with detailed. on a 300 million row table it usually takes around 30 minutes. in a db with 2 tables that are...