One good way to get a complete environmental picture is to run the
sqldiag.exe program provided with SQL Server 2008 on your production box (which you would have to re-create on an alternate site if a disaster occurred). It is located in the
Binn directory where all SQL Server executables reside (
C:\Program Files\Microsoft SQL Server\100\Tools\Binn). It shows how the server is configured, all hardware and software components (and their versions), memory sizes, CPU types, operating system version and build information, paging file information, environment variables, and so on. If you run this program on your production server periodically, it serves as good environment documentation to supplement your disaster recovery plan. This ...