Monday, October 1, 2012

Best Practices for Installing SQL Server 2008 R2


Recommendations For Installing
      ¨  Use NTFS file system
      ¨  Do not install on a compressed drive
      ¨  Do not install SQL Server on a Domain Controller
      ¨  Requires setup administrative privileges

Software Requirements
      ¨  .Net Framework 3.5 SP1
      ¨  Windows Installer 4.5 or later
      ¨  Internet Explorer 6 SP1
      ¨  PowerShell
      ¨  Visual Studio 2008 SP1 prior to run SQL Server setup

Hardware Requirements
      ¨  At least 3.6 GB Hard Disk
      ¨  Memory                              Min        Recommended                
                  ¡  Datacenter             1 GB       4 GB or more                    
                  ¡  Entrprise                 1 GB       4 GB or more                    
                  ¡  Standard                 1 GB       4 GB or more

¨  CPU
                  ¡  2 GHz or Faster

¨  Supported Operating Systems.
                  ¡  All Edition
                              ú  Windows Server 2008 Standard or higher
                              ú  Windows Server 2003 Standard SP2 or higher

¡  Developer and Express
                              ú  Windows XP Professional SP2 or higher
                              ú  Windows Vista Home Basic or higher

¨  1024 x 768 video resolution.