Microsoft SQL Server 2008 Standard R2

Product information "Microsoft SQL Server 2008 Standard R2"

SQL Server 2008 R2 helps all your users make informed decisions. SQL Server 2008 R2 is a comprehensive data platform that provides increased security, reliability, manageability, and scalability for your business-critical applications. Developers are given the opportunity to create new applications that can store and use any data type on any Device. Protect your valuable information with transparent data encryption, expandable key management and monitoring capabilities. Ensure business continuity with improved database mirring, automatic data page recovery, log stream compression and advanced event handling. Be productive. To take advantage of the new opportunities offered by today's rapidly changing business environment, companies must be able to quickly create and deploy data-driven solutions. SQL Server 2008 R2 reduces the time and cost of developing and managing applications. Microsoft SQL Server 2008 allows programmers to simplify application development. It is a comprehensive platform to provide Business Intelligence exactly where your users want it. Microsoft SQL Server is offered in different editions to give you exactly the performance you need for your business. In addition to the free Express Version, which supports only one of several existing processors and one gigabyte of available main memory, and the entry-level Workgroup Edition, which supports up to two processors and up to 4 GB of available main memory, the SQL Server 2008 R2 Standard Version offered here already addresses up to 4 processors and up to 64 GB of main memory. It is therefore predestined for demanding database tasks. Microsoft Office and Windows are registered trademarks of Microsoft Corporation. Used names or pictures remain property of the respective companies.

Hardware requirements

The following memory and processor requirements apply to all editions of SQL Server:

HARDWARE REQUIREMENTS
Component	Requirement
Hard Disk	SQL Server requires a minimum of 6 GB of available hard-disk space. Disk space requirements will vary with the SQL Server components you install. For more information, see Hard Disk Space Requirements later in this article. For information on supported storage types for data files, see Storage Types for Data Files.
Monitor	SQL Server requires Super-VGA (800x600) or higher resolution monitor.
Internet	Internet functionality requires Internet access (fees may apply).
Memory *	Minimum: Express Editions: 512 MB All other editions: 1 GB Recommended: Express Editions: 1 GB All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.
Processor Speed	Minimum: x64 Processor: 1.4 GHz Recommended: 2.0 GHz or faster
Processor Type	x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support

Note : Installation of SQL Server is supported on x64 processors only. It is no longer supported on x86 processors.

* The minimum memory required for installing the Data Quality Server component in Data Quality Services (DQS) is 2 GB of RAM, which is different from the SQL Server minimum memory requirement. For information about installing DQS, see Install Data Quality Services.

Software requirements

The following requirements apply to all installations:

SOFTWARE REQUIREMENTS
Component	Requirement
Operating system	Windows 10 TH1 1507 or greater Windows Server 2016 or greater
.NET Framework	Minimum operating systems includes minimum .NET framework.
Network Software	Supported operating systems for SQL Server have built-in network software. Named and default instances of a stand-alone installation support the following network protocols: Shared memory, Named Pipes, and TCP/IP.