sqldiag.exe
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 ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
