Microsoft SQL Server 2008 R2 Unleashed- P239:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 2344 CHAPTER 56 SQL Server Disaster Recovery Planning exec sp_linkedservers Returns the list of linked servers defined in the local server. exec sp_helplinkedsrvlogin Provides information about login mappings defined against a specific linked server used for distributed queries and remote stored procedures. exec sp_server_info Returns a list of attribute names and matching values for Microsoft SQL Server. exec sp_helpdb dbnamexyz Provides information about a specified database or all databases. This includes the database allocation names sizes and locations. use dbnamexyz go exec sp_spaceused exec sp_spaceused Set of SQL statements that provide the actual database usage information of both data and indexes for the specified database name dbnamexyz . use dbnamexyz go exec sp_spaceused go exec sp_configure - Get the current SQL Server configuration values by running sp_configure with the show advanced option USE master EXEC sp_configure show advanced option1 1 RECONFIGURE go EXEC sp_configure Go name minimum maximum config_value run value access check cache bucket count 0 65536 0 0 access check cache quota 0 2147483647 0 0 Ad Hoc Distributed Queries 0 1 0 0 affinity I O mask -2147483648 2147483647 0 0 affinity mask -2147483648 2147483647 0 0 affinity64 I O mask -2147483648 2147483647 0 0 affinity64 mask -2147483648 2147483647 0 0 Agent XPs 0 1 1 1 The Overall Disaster Recovery Process 2345 allow updates 0 1 0 0 awe enabled 0 1 0 0 backup compression default 0 1 0 0 blocked process threshold s 0 86400 0 0 c2 audit mode 0 1 0 0 clr enabled 0 1 0 0 common criteria compliance enabled 0 1 0 0 cost threshold for parallelism 0 32767 5 5 cross db ownership chaining 0 1 0 0 cursor threshold -1 2147483647 -1 -1 Database Mail XPs 0 1 0 0 default full-text language 0 2147483647 1033 1033 default language 0 9999 0 0 default trace enabled 0 1 1 1 disallow results from triggers 0 1 0 0 EKM provider enabled 0 1 0 0 filestream access level 0 2 2 2 fill factor 0 100 0 0 ft crawl .
