O'Reilly logo

Microsoft® SQL Server 2008 R2 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required