DataBase « Govardhan Gunnala

Hardware and Software Requirements for Installing SQL Server 2012

May 12, 2012 gunnalag Leave a comment

Hardware and Software Requirements for Installing SQL Server 2012

The following sections list the minimum hardware and software requirements to install and run SQL Server 2012. For more information about requirements for Analysis Services in SharePoint integrated mode, see Hardware and Software Requirements (PowerPivot for SharePoint and Reporting Services in SharePoint Mode).

For both 32-bit and 64-bit editions of SQL Server 2012, the following apply:

We recommend that you run SQL Server 2012 on computers with the NTFS file format. Installing SQL Server 2012 on a computer with FAT32 file system is supported but not recommended as it is less secure than the NTFS file system.
SQL Server Setup will block installations on read-only, mapped, or compressed drives.
For information about using SQL Server 2012 tools to prepare for an upgrade to SQL Server 2012, see Use Upgrade Advisor to Prepare for Upgrades.
To make sure that the Visual Studio component can be installed correctly, SQL Server requires you to install an update. SQL Server Setup checks for the presence of this update and then requires you to download and install the update before you can continue with the SQL Server installation. To avoid the interruption during SQL Server Setup, you can download and install the update before running SQL Server Setup as described below (or install all the updates for .NET 3.5 SP1 available on Windows Update):
- If you install SQL Server 2012 on a computer with the Windows Vista SP2 or Windows Server 2008 SP2 operating system, you can get the required update from here.
- If you install SQL Server 2012 on a computer with the Windows 7 SP1 or Windows server 2008 R2 SP1 operating system, this update is included.
The installation of SQL Server 2012 fails if you launch the setup through Terminal Services Client. Launching SQL Server Setup through Terminal Services Client is not supported.

Hardware and Software Requirements

The following requirements apply to all SQL Server 2012 installations:

Component

Requirement

Framework1

.NET 3.5 SP1 is a requirement for SQL Server 2012 when you select Database Engine, Reporting Services, Replication, Master Data Services, Data Quality Services, or SQL Server Management Studio, and it is no longer installed by SQL Server Setup.

If you run Setup on a computer with the Windows Vista SP2 or Windows Server 2008 SP2 operating system, and you do not have .NET 3.5 SP1, SQL Server Setup requires you to download and install.NET 3.5 SP1 before you can continue with the SQL Server installation. The error message includes a link to the download center, or you can download .NET 3.5 SP1 from Windows Update. To avoid interruption during SQL Server Setup, you can download and install .NET 3.5 SP1 before you run SQL Server Setup.
If you run Setup on a computer with the Windows Server 2008 R2 SP1 operating system, you must enable .NET Framework 3.5 SP1 before you install SQL Server 2012.

.NET 4.0 is a requirement for SQL Server 2012. SQL Server installs .NET 4.0 during the feature installation step. SQL Server Express does not install .NET 4.0 on the Server Core mode of Windows Server 2008 R2 SP1. You must install .NET 4.0 before you install SQL Server Express on a Server Core installation of Windows Server 2008 R2 SP1.

SQL Server Setup installs the following software components required by the product:

.NET Framework 4 1
SQL Server Native Client
SQL Server Setup support files

Windows PowerShell

SQL Server 2012 does not install or enable Windows PowerShell 2.0; however Windows PowerShell 2.0 is an installation prerequisite for Database Engine components and SQL Server Management Studio. If Setup reports that Windows PowerShell 2.0 is not present, you can install or enable it by following the instructions on the Windows Management Framework page.

Network Software

Supported operating systems for SQL Server 2012 have built-in network software. Named and default instances of a stand-alone installation support the following network protocols:

Shared memory
Named Pipes
TCP/IP
VIA

Note

Shared memory and VIA are not supported on failover clusters.
The VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

For more information about Network Protocols and Network Libraries, see Network Protocols and Network Libraries.

Virtualization

SQL Server 2012 is supported in virtual machine environments running on the Hyper-V role in Windows Server 2008 SP2 Standard, Enterprise and Datacenter editions, and Windows Server 2008 R2 SP1 Standard, Enterprise, and Datacenter editions.

In addition to resources required by the parent partition, each virtual machine (child partition) must be provided with sufficient processor resources, memory, and disk resources for its SQL Server 2012 instance. Requirements are listed later in this topic.2

Within the Hyper-V role on Windows Server 2008 SP2 and Windows Server 2008 R2 SP1, a maximum of four virtual processors can be allocated to virtual machines running Windows Server 2008 SP2 or Windows Server 2008 R2 SP1 32-bit or 64-bit editions. For more information on compute capacity limits for different editions of SQL Server 2012 and how they differ in physical and virtualized environments with hyperthreaded processors, see Compute Capacity Limits by Edition of SQL Server.

Notes:

Important

We recommend that SQL Server 2012 be shut down before shutting down the virtual machine.
For more information about the Hyper-V role in Windows Server 2008 SP2 and Windows Server 2008 R2, see the Windows Server 2008 Web site.
Guest failover clustering is supported in SQL Server 2012. For more information about the supported versions of SQL Server and operating systems for guest failover clustering, and the support for virtualization, see Support policy for Microsoft SQL Server products running in a hardware virtual environment.

Internet Software

Internet Explorer 7 or a later version is required for Microsoft Management Console (MMC), SQL Server Data Tools (SSDT), the Report Designer component of Reporting Services, and HTML Help.

Hard Disk

SQL Server 2012 requires a minimum of 6 GB of available hard-disk space.

Disk space requirements will vary with the SQL Server 2012 components you install. For more information, see Hard Disk Space Requirements (32-Bit and 64 Bit) later in this topic. For information on supported storage types for data files, see Storage Types for Data Files.

Drive

A DVD drive, as appropriate, is required for installation from disc.

Monitor

SQL Server 2012 requires Super-VGA (800×600) or higher resolution monitor.

Internet

Internet functionality requires Internet access (fees may apply).

1If you are installing the SQL Server Express editions, ensure that an Internet connection is available on the computer. SQL Server Setup downloads and installs the .NET Framework 4 because it is not included in the SQL Server Express media. SQL Server Setup will download.NET Framework 4 to complete the installation of the prerequisites.

2Running SQL Server 2012 on a virtual machine will be slower than running natively because of the overhead of virtualization.

Processor, Memory, and Operating System Requirements

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

Component	Requirement
Memory[1]	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: x86 Processor: 1.0 GHz x86 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 x86 Processor: Pentium III-compatible processor or faster

[1]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 2012 minimum memory requirement. For information about installing DQS, see Install Data Quality Services.

WOW64 Support:

WOW64 (Windows 32-bit on Windows 64-bit) is a feature of 64-bit editions of Windows that enables 32-bit applications to run natively in 32-bit mode. Applications function in 32-bit mode, even though the underlying operating system is a 64-bit operating system.

On a supported 64-bit operating system, SQL Server 32-bit edition can be installed to the WOW64 32-bit subsystem of a 64-bit server. WOW64 is supported only for stand-alone instances of SQL Server. WOW64 is not supported for SQL Server failover cluster installations.
For SQL Server 64-bit edition installations on supported 64-bit operating systems, Management Tools are supported in WOW64. For more information about supported operating systems, select an edition of SQL Server 2012 from the sections below.

Server Core Support:

SQL Server 2012 is now supported on a Server Core installation of Windows Server 2008 R2. Installing SQL Server 2012 is supported on the Server Core mode of the following Windows Server 2008 R2 editions:

Windows Server 2008 R2 SP1 64-bit x64 Datacenter
Windows Server 2008 R2 SP1 64-bit x64 Enterprise
Windows Server 2008 R2 SP1 64-bit x64 Standard
Windows Server 2008 R2 SP1 64-bit x64 Web

For more information on installing SQL Server 2012 on Server Core, see Install SQL Server 2012 on Server Core.

Note

SQL Server editions that are supported on Windows Server 2008 R2 64-bit x64 Standard edition are also supported on Windows Small Business Server 64-bit x64.

Operating System Support:

The SQL Server 2012 editions are classified into the following:

Principal Editions of SQL Server 2012

The following table shows the operating system requirements for the principal editions of SQL Server 2012:

SQL Server Edition	32-bit	64-bit
SQL Server Enterprise	Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Web Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Web Windows Server 2008 SP2 32-bit Datacenter Windows Server 2008 SP2 32-bit Enterprise Windows Server 2008 SP2 32-bit Standard Windows Server 2008 SP2 32-bit Web	Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Web Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Web
SQL Server Business Intelligence	Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Web Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Web Windows Server 2008 SP2 32-bit Datacenter Windows Server 2008 SP2 32-bit Enterprise Windows Server 2008 SP2 32-bit Standard Windows Server 2008 SP2 32-bit Web	Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Web Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Web
SQL Server Standard	Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Foundation Windows Server 2008 R2 SP1 64-bit Web Windows 7 SP1 64-bit Ultimate Windows 7 SP1 64-bit Enterprise Windows 7 SP1 64-bit Professional Windows 7 SP1 32-bit Ultimate Windows 7 SP1 32-bit Enterprise Windows 7 SP1 32-bit Professional Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Foundation Windows Server 2008 SP2 64-bit Web Windows Server 2008 SP2 32-bit Datacenter Windows Server 2008 SP2 32-bit Enterprise Windows Server 2008 SP2 32-bit Standard Windows Server 2008 SP2 32-bit Web Windows Vista SP2 64-bit Ultimate Windows Vista SP2 64-bit Enterprise Windows Vista SP2 64-bit Business Windows Vista SP2 32-bit Ultimate Windows Vista SP2 32-bit Enterprise Windows Vista SP2 32-bit Business	Windows Server 2008 R2 SP1 64-bit Datacenter Windows Server 2008 R2 SP1 64-bit Enterprise Windows Server 2008 R2 SP1 64-bit Standard Windows Server 2008 R2 SP1 64-bit Foundation Windows Server 2008 R2 SP1 64-bit Web Windows 7 SP1 64-bit Ultimate Windows 7 SP1 64-bit Enterprise Windows 7 SP1 64-bit Professional Windows Server 2008 SP2 64-bit Datacenter Windows Server 2008 SP2 64-bit Enterprise Windows Server 2008 SP2 64-bit Standard Windows Server 2008 SP2 64-bit Foundation Windows Server 2008 SP2 64-bit Web Windows Vista SP2 64-bit Ultimate Windows Vista SP2 64-bit Enterprise Windows Vista SP2 64-bit Business

Specialized Editions of SQL Server SQL Server 2012

The following table shows the operating system requirements for the specialized editions of SQL Server 2012:

SQL Server Edition

32-bit

64-bit

SQL Server Web

Windows Server 2008 R2 SP1 64-bit Datacenter

Windows Server 2008 R2 SP1 64-bit Enterprise

Windows Server 2008 R2 SP1 64-bit Standard

Windows Server 2008 R2 SP1 64-bit Web

Windows Server 2008 SP2 64-bit Datacenter

Windows Server 2008 SP2 64-bit Enterprise

Windows Server 2008 SP2 64-bit Standard

Windows Server 2008 SP2 64-bit Web

Windows Server 2008 SP2 32-bit Datacenter

Windows Server 2008 SP2 32-bit Enterprise

Windows Server 2008 SP2 32-bit Standard

Windows Server 2008 SP2 32-bit Web

Windows Server 2008 R2 SP1 64-bit Datacenter

Windows Server 2008 R2 SP1 64-bit Enterprise

Windows Server 2008 R2 SP1 64-bit Standard

Windows Server 2008 R2 SP1 64-bit Web

Windows Server 2008 SP2 64-bit Datacenter

Windows Server 2008 SP2 64-bit Enterprise

Windows Server 2008 SP2 64-bit Standard

Windows Server 2008 SP2 64-bit Web

Breadth Editions of SQL Server 2012

The following table shows the operating system requirements for the breadth editions of SQL Server 2012:

SQL Server Edition

32-bit

64-bit

SQL Server Developer

Windows Server 2008 R2 SP1 64-bit Datacenter

Windows Server 2008 R2 SP1 64-bit Enterprise

Windows Server 2008 R2 SP1 64 Standard

Windows Server 2008 R2 SP1 64-bit Web

Windows 7 SP1 64-bit Ultimate

Windows 7 SP1 64-bit Enterprise

Windows 7 SP1 64-bit Professional

Windows 7 SP1 64-bit Home Premium

Windows 7 SP1 64-bit Home Basic

Windows 7 SP1 32-bit Ultimate

Windows 7 SP1 32-bit Enterprise

Windows 7 SP1 32-bit Professional

Windows 7 SP1 32-bit Home Premium

Windows 7 SP1 32-bit Home Basic

Windows Server 2008 SP2 64-bit Datacenter

Windows Server 2008 SP2 64-bit Enterprise

Windows Server 2008 SP2 64-bit Standard

Windows Server 2008 SP2 64-bit Web

Windows Server 2008 SP2 32-bit Datacenter

Windows Server 2008 SP2 32-bit Enterprise

Windows Server 2008 SP2 32-bit Standard

Windows Server 2008 SP2 32-bit Web

Windows Vista SP2 64-bit Ultimate

Windows Vista SP2 64-bit Enterprise

Windows Vista SP2 64-bit Business

Windows Vista SP2 64-bit Home Premium

Windows Vista SP2 64-bit Home Basic

Windows Vista SP2 32-bit Ultimate

Windows Vista SP2 32-bit Enterprise

Windows Vista SP2 32-bit Business

Windows Vista SP2 32-bit Home Premium

Windows Vista SP2 32-bit Home Basic

Windows Server 2008 R2 SP1 64-bit Datacenter

Windows Server 2008 R2 SP1 64-bit Enterprise

Windows Server 2008 R2 SP1 64-bit Standard

Windows Server 2008 R2 SP1 64-bit Web

Windows 7 SP1 64-bit Ultimate

Windows 7 SP1 64-bit Enterprise

Windows 7 SP1 64-bit Professional

Windows 7 SP1 64-bit Home Premium

Windows 7 SP1 64-bit Home Basic

Windows Server 2008 SP2 64-bit Datacenter

Windows Server 2008 SP2 64-bit Enterprise

Windows Server 2008 SP2 64-bit Standard

Windows Server 2008 SP2 64-bit Web

Windows Vista SP2 64-bit Ultimate

Windows Vista SP2 64-bit Enterprise

Windows Vista SP2 64-bit Business

Windows Vista SP2 64-bit Home Premium

Windows Vista SP2 64-bit Home Basic

SQL Server Express

Windows Server 2008 R2 SP1 64-bit Datacenter

Windows Server 2008 R2 SP1 64-bit Enterprise

Windows Server 2008 R2 SP1 64-bit Standard

Windows Server 2008 R2 SP1 64-bit Foundation

Windows Server 2008 R2 SP1 64-bit Web

Windows 7 SP1 64-bit Ultimate

Windows 7 SP1 64-bit Enterprise

Windows 7 SP1 64-bit Professional

Windows 7 SP1 64-bit Home Premium

Windows 7 SP1 64-bit Home Basic

Windows 7 SP1 32-bit Ultimate

Windows 7 SP1 32-bit Enterprise

Windows 7 SP1 32-bit Professional

Windows 7 SP1 32-bit Home Premium

Windows 7 SP1 32-bit Home Basic

Windows Server 2008 SP2 64-bit Datacenter

Windows Server 2008 SP2 64-bit Enterprise

Windows Server 2008 SP2 64-bit Standard

Windows Server 2008 SP2 64-bit Foundation

Windows Server 2008 SP2 64-bit Web

Windows Server 2008 SP2 32-bit Datacenter

Windows Server 2008 SP2 32-bit Enterprise

Windows Server 2008 SP2 32-bit Standard

Windows Server 2008 SP2 32-bit Web

Windows Vista SP2 64-bit Ultimate

Windows Vista SP2 64-bit Enterprise

Windows Vista SP2 64-bit Business

Windows Vista SP2 64-bit Home Premium

Windows Vista SP2 64-bit Home Basic

Windows Vista SP2 32-bit Ultimate

Windows Vista SP2 32-bit Enterprise

Windows Vista SP2 32-bit Business

Windows Vista SP2 32-bit Home Premium

Windows Vista SP2 32-bit Home Basic

Windows Server 2008 R2 SP1 64-bit Datacenter

Windows Server 2008 R2 SP1 64-bit Enterprise

Windows Server 2008 R2 SP1 64-bit Standard

Windows Server 2008 R2 SP1 64-bit Foundation

Windows Server 2008 R2 SP1 64-bit Web

Windows 7 SP1 64-bit Ultimate

Windows 7 SP1 64-bit Enterprise

Windows 7 SP1 64-bit Professional

Windows 7 SP1 64-bit Home Premium

Windows 7 SP1 64-bit Home Basic

Windows Server 2008 SP2 64-bit Datacenter

Windows Server 2008 SP2 64-bit Enterprise

Windows Server 2008 SP2 64-bit Standard

Windows Server 2008 SP2 64-bit Foundation

Windows Server 2008 SP2 64-bit Web

Windows Vista SP2 64-bit Ultimate

Windows Vista SP2 64-bit Enterprise

Windows Vista SP2 64-bit Business

Windows Vista SP2 64-bit Home Premium

Windows Vista SP2 64-bit Home Basic

Cross-Language Support

For more information about cross-language support and considerations for installing SQL Server in localized languages, see Local Language Versions in SQL Server.

Extended System Support

SQL Server 2012 64-bit versions include support for extended systems, also known as Windows 32-bit on Windows 64-bit (WOW64). WOW64 is a feature of 64-bit editions of Windows that enables 32-bit applications to execute natively in 32-bit mode. Applications function in 32-bit mode even though the underlying operating system is 64-bit.

Hard Disk Space Requirements (32-Bit and 64 Bit)

During installation of SQL Server 2012, Windows Installer creates temporary files on the system drive. Before you run Setup to install or upgrade SQL Server, verify that you have at least 6.0 GB of available disk space on the system drive for these files. This requirement applies even if you install SQL Server components to a non-default drive.

Actual hard disk space requirements depend on your system configuration and the features that you decide to install. For a list of features that are supported by the editions of SQL Server, see Features Supported by the Editions of SQL Server 2012.The following table provides disk space requirements for SQL Server 2012 components.

Feature	Disk space requirement
Database Engine and data files, Replication, Full-Text Search, and Data Quality Services	811 MB
Analysis Services and data files	345 MB
Reporting Services and Report Manager	304 MB
Integration Services	591 MB
Master Data Services	243 MB
Client Components (other than SQL Server Books Online components and Integration Services tools)	1823 MB
SQL Server Books Online Components to view and manage help content1	375 KB

1The disk space requirement for downloaded BOL content is 200 MB.

Storage Types for Data Files

The supported storage types for data files are:

Local Disk
Shared Storage
SMB File Share

Important

SMB storage can be hosted by a Windows File Server or a third party SMB storage device. If Windows File Server is used, the Windows File Server version should be 2008 or later. For more information about installing SQL Server using SMB file share as a storage option, see Install SQL Server with SMB fileshare as a storage option.

Caution

SQL Server failover cluster installation supports Local Disk only for installing the tempdb files. Ensure that the path specified for the tempdb data and log files is valid on all the cluster nodes. During failover, if the tempdb directories are not available on the failover target node, the SQL Server resource will fail to come online.

Installing SQL Server on a Domain Controller

For security reasons, we recommend that you do not install SQL Server 2012 on a domain controller. SQL Server Setup will not block installation on a computer that is a domain controller, but the following limitations apply:

You cannot run SQL Server services on a domain controller under a local service account.
After SQL Server is installed on a computer, you cannot change the computer from a domain member to a domain controller. You must uninstall SQL Server before you change the host computer to a domain controller.
After SQL Server is installed on a computer, you cannot change the computer from a domain controller to a domain member. You must uninstall SQL Server before you change the host computer to a domain member.
SQL Server failover cluster instances are not supported where cluster nodes are domain controllers.
SQL Server Setup cannot create security groups or provision SQL Server service accounts on a read-only domain controller. In this scenario, Setup will fail.

Hardware and Software Requirements for Installing SQL Server 2008

May 12, 2012 gunnalag Leave a comment

Hardware and Software Requirements for Installing SQL Server 2008

The following sections list the minimum hardware and software requirements to install and run SQL Server 2008.

For both 32-bit and 64-bit editions of SQL Server 2008, the following apply:

SQL Server 2008 Enterprise is available for evaluation during a 180-day trial period. For more information, see the SQL Server: How to Buy Web site.
Microsoft recommends that you run SQL Server 2008 on computers with the NTFS file format. For upgrades to SQL Server 2008, FAT32 file systems will not be blocked.
SQL Server Setup will block installations on read-only or compressed drives.
For information about using SQL Server 2008 tools to prepare for an upgrade to SQL Server 2008, see Using Upgrade Advisor to Prepare for Upgrades.
SQL Server does not install the .NET Framework 3.5 software development kit (SDK). However, the SDK contains tools that are useful when you use the .NET Framework for SQL Server development. You can download the .NET Framework SDK from the .NET Framework Web site.
Requirements to restart computers during SQL Server Setup: Installation of the .NET Framework requires a restart of the operating system. If Windows Installer installation also requires a restart, Setup will wait until the .NET Framework and Windows Installer components have installed before restarting.
For more information about features of SQL Server 2008, see the following:
- Editions and Components of SQL Server 2008
- Features Supported by the Editions of SQL Server 2008

Hardware and Software Requirements

The following requirements apply to all SQL Server 2008 installations:

Component	Requirement
Framework2	SQL Server Setup installs the following software components required by the product: .NET Framework 3.5 SP11 SQL Server Native Client SQL Server Setup support files
Software2	SQL Server Setup requires Microsoft Windows Installer 4.5 or a later version After installing required components, SQL Server Setup will verify that the computer where SQL Server 2008 will be installed also meets all the other requirements for a successful installation. For more information, see Check Parameters for the System Configuration Checker.
Network Software	Network software requirements for the 64-bit versions of SQL Server 2008 are the same as the requirements for the 32-bit versions. Supported operating systems have built-in network software. Stand-alone named and default instances support the following network protocols: Shared memory Named Pipes TCP/IP VIA Note Shared memory and VIA are not supported on failover clusters.
Virtualization	SQL Server 2008 is supported in virtual machine environments running on the Hyper-V role in Windows Server 2008 R2 and Windows Server 2008 Standard, Enterprise and Datacenter editions. The virtual machine must run an operating system supported for the specific SQL Server 2008 edition listed later in this topic. In addition to resources required by the parent partition, each virtual machine (child partition) must be provided with sufficient processor resources, memory, and disk resources for its SQL Server 2008 instance. Requirements are listed later in this topic.3 Within the Hyper-V role on Windows Server 2008, a maximum of four virtual processors can be allocated to virtual machines running Windows Server 2008 32-bit or 64-bit editions. A maximum of 2 virtual processors can be allocated to virtual computers that are running Windows Server 2003 32-bit editions. For virtual computer that host other operating systems, a maximum of one virtual processor can be allocated to virtual computers. Notes: It is recommended that SQL Server 2008 be shut down before shutting down or the virtual machine. For more information about the Hyper-V role in Windows Server 2008, see the Windows Server 2008 Web site. Guest failover clustering is supported in SQL Server 2008. For more information about the supported versions of SQL Server and operating systems for guest failover clustering, and the support for virtualization, see Support policy for Microsoft SQL Server products running in a hardware virtual environment.
Internet Software	Microsoft Internet Explorer 6 SP1 or a later version is required for all installations of SQL Server 2008. Internet Explorer 6 SP1 or a later version is required for Microsoft Management Console (MMC), SQL Server Management Studio, Business Intelligence Development Studio, the Report Designer component of Reporting Services, and HTML Help.
Hard Disk	Disk space requirements will vary with the SQL Server 2008 components you install. For more information, see Hard disk space requirements later in this topic.
Drive	A CD or DVD drive, as appropriate, is required for installation from disc.
Display	SQL Server 2008 graphical tools require VGA or higher resolution: at least 1,024×768 pixel resolution.
Other Devices	Pointing device: A Microsoft mouse or compatible pointing device is required.

1The following .NET Framework versions are required:

SQL Server 2008 on Windows Server 2003 (64-bit) IA64 — .NET Framework 2.0 SP2
SQL Server Express — .NET Framework 2.0 SP2
All other editions of SQL Server 2008 — .NET Framework 3.5 SP1

Installation of .NET Framework requires a restart of the operating system. If Windows Installer installation also requires a restart, Setup will wait until .NET Framework and Windows Installer components have installed before restarting.

Note

Installing .NET Framework 2.0 SP2: .NET Framework 2.0 SP2 is not available as a separate download. You will need to install .NET Framework 3.5 SP1 which includes .NET Framework 2.0 SP2.

2SQL Server Setup will not install the following required components for SQL Server Express ,SQL Server Express with Tools, and SQL Server Express with Advanced Services. You must install these components manually before you run SQL Server Setup:

SQL Server Express — .NET Framework 2.0 SP2 and Windows installer 4.5. On Windows Vista, use .NET Framework 3.5 SP1.
SQL Server Express with Advanced Services — .NET Framework 3.5 SP1, Windows Installer 4.5, and Windows PowerShell 1.0.
SQL Server Express with Tools — .NET Framework 3.5 SP1, Windows Installer 4.5, and Windows PowerShell 1.0.

Note

SQL Server 2008 Express SP1 is now available in two formats: SQL Server 2008 Express SP1 with the Microsoft .NET Framework version 3.5 SP1 support and SQL Server 2008 Express SP1 with the Microsoft .NET Framework version 4.0 Beta 2 support. There are no functional differences between these two formats. Either package supports computers running .NET Framework 2.0 SP2 or .NET Framework 3.5 SP1. For computers running .NET Framework 4 Beta 2 only, install SQL Server 2008 Express SP1 with the .NET Framework 4 Beta 2 support.

3As with all virtualization technologies, SQL Server 2008 running in a Windows Server 2008 Hyper-V virtual computer will be slower than on a physical computer with the same physical resources.

Processor, Memory, and Operating System Requirements

To view system requirements, select an edition of SQL Server 2008:

Server Editions of SQL Server 2008

Note

SQL Server Enterprise evaluation is available for a 180-day trial period.

Specialized Editions of SQL Server 2008

Additional information in this topic

Server Editions (64-bit and 32-bit)

SQL Server 2008 Enterprise (64-bit) IA64

The following table shows system requirements for SQL Server 2008 Enterprise (64-bit) IA64. Note that this edition of SQL Server 2008 is not available in the following localized versions: Italian, Spanish, Brazilian (Portuguese), or Russian.

Component	Requirement
Processor	Processor type: Itanium processor or faster Processor speed: Recommended: 1.0 GHz or faster
Operating System	Windows Server 2008 R2 Itanium IA642 Windows Server 2008 64-bit Itanium1 Windows Server 2003 SP2 64-bit Itanium Datacenter1 Windows Server 2003 SP2 64-bit Itanium Enterprise1
Memory	RAM: Minimum: 512 MB Recommended: 2.048 GB or more Maximum: Operating system maximum

1Management Tools are supported in WOW64, a feature of 64-bit editions of Windows that enables 32-bit applications to run natively in 32-bit mode. Applications function in 32-bit mode, even though the underlying operating system is running on the 64-bit operating system. WOW64 is supported only for stand-alone instances of SQL Server. WOW64 is not supported for SQL Server failover cluster installations.

2Supported only on SQL Server SP1 or higher

Note

SQL Server 2008 is not supported on Windows Server 2008 and Windows Server 2008 R2 Server Core installations.

SQL Server 2008 Enterprise (64-bit) x64

The following table shows system requirements for SQL Server 2008 Enterprise (64-bit) x64:

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating System	Windows Server 2003 SP2 64-bit x64 Standard1 Windows Server 2003 SP2 64-bit x64 Datacenter1 Windows Server 2003 SP2 64-bit x64 Enterprise1 Windows Server 2008 64-bit x64 Standard Windows Server 2008 64-bit x64 Standard without Hyper-V Windows Server 2008 64-bit x64 Datacenter Windows Server 2008 64-bit x64 Datacenter without Hyper-V1 Windows Server 2008 64-bit x64 Enterprise, Windows Server 2008 64-bit x64 Enterprise without Hyper-V1 Windows Server 2008 R2 64-bit x64 Web1,2 Windows Server 2008 R2 64-bit x64 Standard1,2 Windows Server 2008 R2 64-bit x64 Enterprise1,2 Windows Server 2008 R2 64-bit x64 Datacenter1,2
Memory	RAM: Minimum:512 MB Recommended: 2.048 GB or more Maximum: Operating system maximum

1Management Tools are supported in WOW64, a feature of 64-bit editions of Windows that enables 32-bit applications to run natively in 32-bit mode. Applications function in 32-bit mode even though the underlying operating system is running on the 64-bit operating system. WOW64 is supported only for stand-alone instances of SQL Server. WOW64 is not supported for SQL Server failover cluster installations.

2Supported only on SQL Server SP1 or higher.

Note

SQL Server 2008 is not supported on Windows Server 2008 and Windows Server 2008 R2 Server Core installations.

SQL Server 2008 Standard (64-bit) x64

The following table shows system requirements for SQL Server 2008 Standard (64-bit) x64:

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating System	Windows XP Professional x64 Windows Server 2003 SP2 64-bit x64 Standard1 Windows Server 2003 SP2 64-bit x64 Datacenter1 Windows Server 2003 SP2 64-bit x64 Enterprise1 Windows Vista Ultimate x64 Windows Vista Enterprise x64 Windows Vista Business x64 Windows Server 2008 x64 Web1 Windows Server 2008 x64 Standard, Windows Server 2008 x64 Standard without Hyper-V1 Windows Server 2008 x64 Datacenter, Windows Server 2008 x64 Datacenter without Hyper-V1 Windows Server 2008 x64 Enterprise, Windows Server 2008 x64 Enterprise without Hyper-V1 Windows Small Business Server 20082 Windows Server 2008 for Windows Essential Server Solutions2 Windows Server 2008 without Hyper-V for Windows Essential Server Solutions2 Windows 7 64-bit x64 Ultimate1,3 Windows 7 64-bit x64 Enterprise1,3 Windows 7 64-bit x64 Professional1,3 Windows 2008 R2 64-bit x64 Web1,3 Windows 2008 R2 Foundation Server1,3 Windows 2008 R2 64-bit x64 Standard1,3 Windows 2008 R2 64-bit x64 Enterprise1,3 Windows 2008 R2 64-bit x64 Datacenter1,3
Memory	RAM: Minimum:512 MB Recommended: 2.048 GB or more Maximum: Operating system maximum

1Management Tools are supported in WOW64, a feature of 64-bit editions of Microsoft Windows that enables 32-bit applications to execute natively in 32-bit mode. Applications function in 32-bit mode even though the underlying operating system is running on the 64-bit operating system. WOW64 is supported only for stand-alone instances of SQL Server. WOW64 is not supported for SQL Server failover cluster installations.

2Supported Operating Systems for SQL Server Standard for Small Business

3Supported only on SQL Server SP1 or higher.

Note

SQL Server 2008 is not supported on Windows Server 2008 and Windows Server 2008 R2 Server Core installations.

SQL Server 2008 Enterprise (32-bit)

The following table shows the system requirements for SQL Server 2008 Enterprise (32-bit):

Component	Requirement
Processor	Processor type: Pentium III-compatible processor or faster Processor speed: Minimum: 1.0 GHz Recommended: 2.0 GHz or faster
Operating System	Windows Server 2003 SP2 Small Business Server R2 Standard Windows Server 2003 SP2 Small Business Server R2 Premium Windows Server 2003 SP2 Standard Windows Server 2003 SP2 Enterprise Windows Server 2003 SP2 Datacenter Windows Server 2003 Small Business Server SP2 Standard Windows Server 2003 Small Business Server SP2 Premium Windows Server 2003 SP2 64-bit x64 Standard1 Windows Server 2003 SP2 64-bit x64 Datacenter1 Windows Server 2003 SP2 64-bit x64 Enterprise1 Windows Server 2008 Standard (with and without Hyper-V) Windows Server 2008 Web Windows Server 2008 Datacenter Windows Server 2008 Datacenter without Hyper-V Windows Server 2008 Enterprise Windows Server 2008 Enterprise without Hyper-V Windows Server 2008 x64 Standard Windows Server 2008 x64 Standard without Hyper-V1 Windows Server 2008 x64 Datacenter Windows Server 2008 x64 Datacenter without Hyper-V1 Windows Server 2008 x64 Enterprise Windows Server 2008 x64 Enterprise without Hyper-V1 Windows Server 2008 R2 64-bit x64 Web1,2 Windows Server 2008 R2 64-bit x64 Standard1,2 Windows Server 2008 R2 64-bit x64 Enterprise1,2 Windows Server 2008 R2 64-bit x64 Datacenter1,2
Memory	RAM: Minimum: 512 MB Recommended: 2.048 GB or more Maximum: Operating system maximum

1This edition of SQL Server can be installed to the Windows on Windows (WOW64) 32-bit subsystem of a 64-bit server. WOW64 is supported only for stand-alone instances of SQL Server. WOW64 is not supported for SQL Server failover cluster installations.

2Supported only on SQL Server SP1 or higher.

SQL Server 2008 Standard (32-bit)

The following table shows the system requirements for SQL Server 2008 Standard (32-bit):

Component	Requirement
Processor	Processor type: Pentium III-compatible processor or faster Processor speed: Minimum: 1.0 GHz Recommended: 2.0 GHz or faster
Operating System	Windows XP Professional SP2 Windows XP SP2 Tablet Windows XP x64 Professional1 Windows XP SP2 Media Center 2002 Windows XP SP2 Media Center 2004 Windows XP Media Center 2005 Windows XP Professional Reduced Media Windows Server 2003 SP2 Small Business Server R2 Standard Windows Server 2003 SP2 Small Business Server R2 Premium Windows Server 2003 SP2 Standard Windows Server 2003 SP2 Enterprise Windows Server 2003 SP2 Datacenter Windows Server 2003 SP2 Small Business Server Standard Windows Server 2003 SP2 Small Business Server Premium Windows Server 2003 SP2 64-bit x64 Standard1 Windows Server 2003 SP2 64-bit x64 Datacenter1 Windows Server 2003 SP2 64-bit x64 Enterprise1 Windows Vista Ultimate Windows Vista Enterprise Windows Vista Business Windows Vista Ultimate x641 Windows Vista Enterprise x641 Windows Vista Business x641 Windows Server 2008 Web Windows Server 2008 Standard Server Windows Server 2008 Standard Server without Hyper-V Windows Server 2008 Datacenter Windows Server 2008 Datacenter without Hyper-V Windows Server 2008 Enterprise Windows Server 2008 Enterprise without Hyper-V Windows Server 2008 x64 Standard Windows Server 2008 x64 Standard without Hyper-V1 Windows Server 2008 x64 Datacenter Windows Server 2008 x64 Datacenter without Hyper-V1 Windows Server 2008 x64 Enterprise Windows Server 2008 x64 Enterprise without Hyper-V1 Windows Small Business Server 20082 Windows Server 2008 for Windows Essential Server Solutions2 Windows Server 2008 without Hyper-V for Windows Essential Server Solutions2 Windows 7 Ultimate3 Windows 7 Enterprise3 Windows 7 Professional3 Windows 7 64-bit x64 Ultimate1,3 Windows 7 64-bit x64 Enterprise1,3 Windows 7 64-bit x64 Professional1,3 Windows Server 2008 R2 64-bit x64 Web1,3 Windows Server 2008 R2 Foundation Server1,3 Windows Server 2008 R2 64-bit x64 Standard1,3 Windows Server 2008 R2 64-bit x64 Enterprise1,3 Windows Server 2008 R2 64-bit x64 Datacenter1,3
Memory	RAM: Minimum: 512 MB Recommended: 2.048 GB or more Maximum: Operating system maximum

2Supported Operating Systems for SQL Server Standard for Small Business

3Supported only on SQL Server SP1 or higher.

Specialized Editions (64-bit and 32-bit)

SQL Server 2008 Developer (64-bit) IA64

The following table shows system requirements for SQL Server 2008 Developer (64-bit) IA64. Note that this edition of SQL Server 2008 is not available in the following localized versions: Italian, Spanish, Brazilian (Portuguese), or Russian.

Component	Requirement
Processor	Processor type: Minimum: Itanium processor or faster Processor speed: Minimum: 1.0 GHz or faster
Operating System	Windows Server 2003 SP2 64-bit Itanium Datacenter1 Windows Server 2003 SP2 64-bit Itanium Enterprise1 Windows Server 2008 64-bit Itanium Edition1 Windows Server 2008 R2 64-bit Itanium Edition1,2
Memory	RAM: Minimum: 512 MB Recommended: 2.048 GB or more Maximum: Operating system maximum

2Supported only on SQL Server SP1 or higher.

Note

SQL Server 2008 is not supported on Windows Server 2008 and Windows Server 2008 R2 Server Core installations.

SQL Server 2008 Developer (64-bit) x64

The following table shows system requirements for SQL Server 2008 Developer (64-bit) x64:

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating System	Windows XP x64 Professional Windows Server 2003 SP2 64-bit x64 Standard1 Windows Server 2003 SP2 64-bit x64 Datacenter1 Windows Server 2003 SP2 64-bit x64 Enterprise1 Windows Vista Ultimate x64 Windows Vista Home Premium x64 Windows Vista Home Basic x64 Windows Vista Enterprise x64 Windows Vista Business x64 Windows Server 2008 64-bit x64 Standard, Windows Server 2008 64-bit x64 Standard without Hyper-V1 Windows Server 2008 64-bit x64 Datacenter, Windows Server 2008 64-bit x64 Datacenter without Hyper-V1 Windows Server 2008 64-bit x64 Enterprise, Windows Server 2008 64-bit x64 Enterprise without Hyper-V1 Windows Server 2008 x64 Web1 Windows 7 64-bit x64 Web1,2 Windows 7 64-bit x64 Home Basic1,2 Windows 7 64-bit x64 Home Premium1,2 Windows 7 64-bit x64 Enterprise1,2 Windows 7 64-bit x64 Ultimate1,2 Windows 7 64-bit x64 Professional1,2 Windows 2008 R2 64-bit x64 Web1,2 Windows 2008 R2 64-bit x64 Standard1,2 Windows 2008 R2 64-bit x64 Enterprise1,2 Windows 2008 R2 64-bit x64 Datacenter1,2
Memory	RAM: Minimum:512 MB Recommended: 2.048 GB or more Maximum: Operating system maximum

2Supported only on SQL Server SP1 or higher.

Note

SQL Server 2008 is not supported on Windows Server 2008 and Windows Server 2008 R2 Server Core installations.

SQL Server 2008 Workgroup (64-bit) x64

The following table shows system requirements for SQL Server 2008 Workgroup (64-bit) x64:

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating System	Windows XP x64 Professional Windows Server 2003 SP2 64-bit x64 Standard1 Windows Server 2003 SP2 64-bit x64 Datacenter1 Windows Server 2003 SP2 64-bit x64 Enterprise1 Windows Vista Ultimate x64 Windows Vista Home Premium x64 Windows Vista Home Basic x64 Windows Vista Enterprise x64 Windows Vista Business x64 Windows Server 2008 x64 Web1 Windows Server 2008 64-bit x64 Standard, Windows Server 2008 64-bit x64 Standard without Hyper-V1 Windows Server 2008 64-bit x64 Datacenter, Windows Server 2008 64-bit x64 Datacenter without Hyper-V1 Windows Server 2008 64-bit x64 Enterprise, Windows Server 2008 64-bit x64 Enterprise without Hyper-V1 Windows 7 64-bit x64 Ultimate2 Windows 7 64-bit x64 Enterprise2 Windows 7 64-bit x64 Professional2 Windows Server 2008 R2 64-bit x64 Web1,2 Windows Server 2008 R2 64-bit x64 Foundation Server1,2 Windows Server 2008 R2 64-bit x64 Standard1,2 Windows Server 2008 R2 64-bit x64 Enterprise1,2 Windows Server 2008 R2 64-bit x64 Datacenter1,2
Memory	RAM: Minimum:512 MB Recommended: 2.048 GB or more Maximum: 4 GB

2Supported only on SQL Server SP1 or higher.

Note

SQL Server 2008 is not supported on Windows Server 2008 and Windows Server 2008 R2 Server Core installations.

SQL Server 2008 Web (64-bit) x64

The following table shows system requirements for SQL Server 2008 Web (64-bit) x64:

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating System	Windows XP x64 Professional Windows Server 2003 SP2 64-bit x64 Standard1 Windows Server 2003 SP2 64-bit x64 Datacenter1 Windows Server 2003 SP2 64-bit x64 Enterprise1 Windows Vista Ultimate x64 Windows Vista Enterprise x64 Windows Vista Business x64 Windows Server 2008 x64 Web Windows Server 2008 x64 Standard, Windows Server 2008 x64 Standard without Hyper-V1 Windows Server 2008 x64 Datacenter, Windows Server 2008 x64 Datacenter without Hyper-V1 Windows Server 2008 x64 Enterprise, Windows Server 2008 x64 Enterprise without Hyper-V1 Windows Server 2008 R2 64-bit x64 Web1,2 Windows Server 2008 R2 64-bit x64 Standard1,2 Windows Server 2008 R2 64-bit x64 Enterprise1,2 Windows Server 2008 R2 64-bit x64 Datacenter1,2
Memory	RAM: Minimum:512 MB Recommended: 2.048 GB or more Maximum: Operating system maximum for the Database Engine, 4 GB for Reporting Services

2Supported only on SQL Server SP1 or higher.

Note

SQL Server 2008 is not supported on Windows Server 2008 and Windows Server 2008 R2 Server Core installations.

SQL Server 2008 Express with Tools(64-bit) x64

The following table shows the system requirements for SQL Server 2008 Express with Tools (64-bit) x64.

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating System	Windows Server 2003 x64 Windows Server 2003 SP2 64-bit x64 Standard1 Windows Server 2003 SP2 64-bit x64 Datacenter1 Windows Server 2003 SP2 64-bit x64 Enterprise1 Windows Vista Ultimate x64 Windows Vista Home Premium x64 Windows Vista Home Basic x64 Windows Vista Enterprise x64 Windows Vista Business x64 Windows Server 2008 64-bit x64 Web1 Windows Server 2008 64-bit x64 Standard Windows Server 2008 64-bit x64 Standard without Hyper-V1 Windows Server 2008 64-bit x64 Datacenter Windows Server 2008 64-bit x64 Datacenter without Hyper-V1 Windows Server 2008 64-bit x64 Enterprise Windows Server 2008 64-bit x64 Enterprise without Hyper-V1 Windows 7 64-bit x64 Ultimate2 Windows 7 64-bit x64 Home Basic2 Windows 7 64-bit x64 Home Premium2 Windows 7 64-bit x64 Enterprise2 Windows 7 64-bit x64 Professional2 Windows 2008 R2 64-bit x64 Web1,2 Windows 2008 R2 64-bit x64 Foundation Server1,2 Windows 2008 R2 64-bit x64 Standard1,2 Windows 2008 R2 64-bit x64 Enterprise1,2 Windows 2008 R2 64-bit x64 Datacenter1,2
Memory	RAM: Minimum:512 MB Recommended: 1 GB Maximum: 1 GB for the

1 Management Tools are supported in WOW64, a feature of 64-bit editions of Windows that enables 32-bit applications to execute natively in 32-bit mode. Applications function in 32-bit mode even though the underlying operating system is running on the 64-bit operating system.

2Supported only on SQL Server SP1 or higher.

SQL Server 2008 Express with Advanced Services (64-bit) x64

The following table shows system requirements for SQL Server 2008 Express with Advanced Services (64-bit) x64:

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating System	Windows Server 2003 x64 Windows Server 2003 SP2 64-bit x64 Standard1 Windows Server 2003 SP2 64-bit x64 Datacenter1 Windows Server 2003 SP2 64-bit x64 Enterprise1 Windows Vista Ultimate x64 Windows Vista Home Premium x64 Windows Vista Home Basic x64 Windows Vista Enterprise x64 Windows Vista Business x64 Windows Server 2008 64-bit x64 Web1 Windows Server 2008 64-bit x64 Standard Windows Server 2008 64-bit x64 Standard without Hyper-V1 Windows Server 2008 64-bit x64 Datacenter Windows Server 2008 64-bit x64 Datacenter without Hyper-V1 Windows Server 2008 64-bit x64 Enterprise Windows Server 2008 64-bit x64 Enterprise without Hyper-V1 Windows 7 64-bit x64 Ultimate2 Windows 7 64-bit x64 Home Basic2 Windows 7 64-bit x64 Home Premium2 Windows 7 64-bit x64 Enterprise2 Windows 7 64-bit x64 Professional2 Windows 7 64-bit x64 Web1,2 Windows 7 64-bit x64 Foundation1,2 Windows 7 64-bit x64 Standard1,2 Windows 7 64-bit x64 Enterprise1,2 Windows 7 64-bit x64 Datacenter1,2
Memory	RAM: Minimum:512 MB Recommended: 1 GB Maximum: 1 GB for the Database Engine, 4 GB for Reporting Services

1Management Tools are supported in WOW64, a feature of 64-bit editions of Windows that enables 32-bit applications to execute natively in 32-bit mode. Applications function in 32-bit mode even though the underlying operating system is running on the 64-bit operating system.

2Supported only on SQL Server SP1 or higher.

SQL Server Developer (32-bit)

The following table shows the system requirements for SQL Server 2008 Developer (32-bit):

Component	Requirement
Processor	Processor type: Pentium III-compatible processor or faster Processor speed: Minimum: 1.0 GHz Recommended: 2.0 GHz or faster
Operating System	Windows XP Home Edition SP2 Windows XP Professional SP2 Windows XP Tablet SP2 Windows XP Professional x64 SP21 Windows XP SP2 Media Center 2002 Windows XP SP2 Media Center 2004 Windows XP Media Center 2005 Windows XP Professional Reduced Media Windows XP Home Edition Reduced Media Windows Server 2003 SP2 Small Business Server R2 Standard Windows Server 2003 SP2 Small Business Server R2 Premium Windows Server 2003 SP2 Standard Windows Server 2003 SP2 Enterprise Windows Server 2003 SP2 Datacenter Windows Server 2003 SP2 Small Business Server Standard Windows Server 2003 SP2 Small Business Server Premium Windows Server 2003 SP2 64-bit x64 Standard1 Windows Server 2003 SP2 64-bit x64 Datacenter1 Windows Server 2003 SP2 64-bit x64 Enterprise1 Windows Vista Ultimate Windows Vista Home Premium Windows Vista Home Basic Windows Vista Starter Edition Windows Vista Enterprise Windows Vista Business Windows Vista Ultimate 64-bit x641 Windows Vista Home Premium 64-bit x641 Windows Vista Home Basic 64-bit x641 Windows Vista Enterprise 64-bit x641 Windows Vista Business 64-bit x641 Windows Server 2008 Web Windows Server 2008 Standard Windows Server 2008 Standard without Hyper-V Windows Server 2008 Enterprise Windows Server 2008 Enterprise without Hyper-V Windows Server 2008 Datacenter Windows Server 2008 Datacenter without Hyper-V Windows Server 2008 64-bit x64 Standard Windows Server 2008 64-bit x64 Standard without Hyper-V Windows Server 2008 Datacenter Windows Server 2008 Datacenter without Hyper-V Windows Server 2008 Enterprise Windows Server 2008 Enterprise without Hyper-V Windows 7 Ultimate2 Windows 7 Home Basic2 Windows 7 Home Premium2 Windows 7 Enterprise2 Windows 7 Professional2 Windows 7 64-bit x64 Ultimate1,2 Windows 7 64-bit x64 Home Basic1,2 Windows 7 64-bit x64 Home Premium1,2 Windows 7 64-bit x64 Enterprise1,2 Windows 7 64-bit x64 Professional1,2 Windows Server 2008 R2 64-bit x64 Web1,2 Windows Server 2008 R2 64-bit x64 Standard1,2 Windows Server 2008 R2 64-bit x64 Enterprise1,2 Windows Server 2008 R2 64-bit x64 Datacenter1,2
Memory	RAM: Minimum: 512 MB Recommended: 2.048 GB or more Maximum: Operating system maximum

1This edition of SQL Server 2008 can be installed to the Windows on Windows (WOW64) 32-bit subsystem of a 64-bit server. WOW64 is supported only for stand-alone instances of SQL Server. WOW64 is not supported for SQL Server failover cluster installations.

2Supported only on SQL Server SP1 or higher.

Note

SQL Server 2008 is not supported on Windows Server 2008 and Windows Server 2008 R2 Server Core installations.

SQL Server Workgroup (32-bit)

The following table shows the system requirements for SQL Server 2008 Workgroup (32-bit):

Component	Requirement
Processor	Processor type: Pentium III-compatible processor or faster Processor speed: Minimum: 1.0 GHz Recommended: 2.0 GHz or faster
Operating System	Windows XP Professional SP2 Windows XP SP2 Tablet Windows XP Professional 64-bit x641 Windows XP SP2 Media Center 2002 Windows XP SP2 Media Center 2004 Windows XP Media Center 2005 Windows XP Professional Reduced Media Windows Server 2003 SP2 Small Business Server R2 Standard Windows Server 2003 SP2 Small Business Server R2 Premium Windows Server 2003 SP2 Standard Windows Server 2003 SP2 Enterprise Windows Server 2003 SP2 Datacenter Windows Server 2003 SP2 Small Business Server Standard Windows Server 2003 SP2 Small Business Server Premium Windows Server 2003 64-bit x64 Standard1 Windows Server 2003 64-bit x64 Datacenter1 Windows Server 2003 64-bit x64 Enterprise1 Windows Vista Vista Ultimate Windows Vista Enterprise Windows Vista Business Windows Vista 64-bit x64 Ultimate1 Windows Vista 64-bit x64 Enterprise1 Windows Vista 64-bit x64 Business1 Windows Server 2008 2008 Web Windows Server 2008 Standard Windows Server 2008 Standard without Hyper-V Windows Server 2008 Datacenter Windows Server 2008 Datacenter without Hyper-V Windows Server 2008 Enterprise Windows Server 2008 Enterprise without Hyper-V Windows Server 2008 64-bit x64 Standard Windows Server 2008 64-bit x64 Standard without Hyper-V1 Windows Server 2008 64-bit x64 Datacenter Windows Server 2008 64-bit x64 Datacenter without Hyper-V1 Windows Server 2008 64-bit x64 Enterprise Windows Server 2008 64-bit x64 Enterprise without Hyper-V1 Windows 7 Ultimate2 Windows 7 Enterprise2 Windows 7 Professional2 Windows 7 64-bit x64 Ultimate1,2 Windows 7 64-bit x64 Enterprise1,2 Windows 7 64-bit x64 Professional1,2 Windows Server 2008 R2 64-bit x64 Web1,2 Windows Server 2008 R2 Foundation Server1,2 Windows Server 2008 R2 Standard1,2 Windows Server 2008 R2 Enterprise1,2 Windows Server 2008 R2 Datacenter1,2
Memory	RAM: Minimum: 512 MB Recommended: 2.048 GB or more Maximum: Operating system maximum for the Database Engine, 4 GB for Reporting Services

1This edition of SQL Server 2008 can be installed to the Windows on Windows (WOW64) 32-bit subsystem of a 64-bit server.

2Supported only on SQL Server SP1 or higher.

Note

SQL Server 2008 is not supported on Windows Server 2008 and Windows Server 2008 R2 Server Core installations.

SQL Server Web (32-bit)

The following table shows the system requirements for SQL Server 2008 Web (32-bit):

Component	Requirement
Processor	Processor type: Pentium III-compatible processor or faster Processor speed: Minimum: 1.0 GHz Recommended: 2.0 GHz or faster
Operating System	Windows XP Professional SP2 Windows XP SP2 Tablet Windows XP Professional XP x641 Windows XP SP2 Media Center 2002 Windows XP SP2 Media Center 2004 Windows XP Media Center 2005 Windows XP Professional Reduced Media Windows Server 2003 SP2 Small Business Server R2 Standard Windows Server 2003 SP2 Small Business Server R2 Premium Windows Server 2003 SP2 Standard Windows Server 2003 SP2 Enterprise Windows Server 2003 SP2 Datacenter Windows Server 2003 SP2 Small Business Server Standard Windows Server 2003 SP2 Small Business Server Premium Windows Server 2003 SP2 64-bit x64 Standard1 Windows Server 2003 SP2 64-bit x64 Datacenter1 Windows Server 2003 SP2 64-bit x64 Enterprise1 Windows Vista Ultimate Windows Vista Enterprise Windows Vista Business Windows Vista Ultimate x641 Windows Vista Enterprise x641 Windows Vista Business x641 Windows Server 2008 Web Windows Server 2008 Standard Server Windows Server 2008 Standard Server without Hyper-V Windows Server 2008 Datacenter Windows Server 2008 Datacenter without Hyper-V Windows Server 2008 Enterprise Windows Server 2008 Enterprise without Hyper-V Windows Server 2008 x64 Standard Windows Server 2008 x64 Standard without Hyper-V1 Windows Server 2008 x64 Datacenter Windows Server 2008 x64 Datacenter without Hyper-V1 Windows Server 2008 x64 Enterprise Windows Server 2008 x64 Enterprise without Hyper-V1 Windows Server 2008 R2 64-bit x64 Web1,2 Windows Server 2008 R2 64-bit x64 Standard1,2 Windows Server 2008 R2 64-bit x64 Enterprise1,2 Windows Server 2008 R2 64-bit x64 Datacenter1,2
Memory	RAM: Minimum: 512 MB Recommended: 2.048 GB or more Maximum: Operating system maximum for the Database Engine, 4 GB for Reporting Services

1This edition of SQL Server 2008 can be installed to the Windows on Windows (WOW64) 32-bit subsystem of a 64-bit server.

2Supported only on SQL Server SP1 or higher.

Note

SQL Server 2008 is not supported on Windows Server 2008 Windows Server 2008 R2 Server Core installations.

SQL Server Express (32-bit), Express with Tools, and Express with Advanced Services (32-bit)

The following table shows the system requirements for SQL Server Express (32-bit),SQL Server Express with Tools, and SQL Server Express with Advanced Services (32-bit):

Component	Requirement
Processor	Processor type: Pentium III-compatible processor or faster Processor speed: Minimum: 1.0 GHz Recommended: 2.0 GHz or faster
Operating System	Windows XP SP2 Home Windows XP SP2 Professional Windows XP SP2 Tablet Windows XP SP2 Media Center 2002 Windows XP SP2 Media Center 2004 Windows XP Media Center 2005 Windows Server 2003 Reduced Media Windows XP Home Edition Reduced Media Windows Server 2003 SP2 Small Business Server R2 Standard Windows Server 2003 SP2 Small Business Server R2 Premium Windows Server 2003 SP2 Standard Windows Server 2003 2003 SP2 Enterprise Windows Server 2003 SP2 Datacenter Windows Server 2003 SP2 Web Edition Windows Server 2003 SP2 Small Business Server Standard Windows Server 2003 SP2 Small Business Server Premium Windows Server 2003 SP2 64-bit x64 Standard1 Windows Server 2003 SP2 64-bit x64 Datacenter1 Windows Server 2003 SP2 64-bit x64 Enterprise1 Windows Vista Ultimate Windows Vista Home Premium Windows Vista Home Basic Windows Vista Enterprise Windows Vista Business Windows Vista Ultimate 64-bit x643 Windows Vista Home Premium 64-bit x643 Windows Vista Home Basic 64-bit x643 Windows Vista Enterprise 64-bit x643 Windows Vista Business 64-bit x643 Windows Server 2008 Standard Server Windows Server 2008 Standard Server without Hyper-V Windows Server 2008 Enterprise Windows Server 2008 Enterprise without Hyper-V Windows Server 2008 Datacenter Windows Server 2008 Datacenter without Hyper-V Windows Server 2008 Web Edition Windows Server 2008 64-bit x64 Web Edition1 Windows Server 2008 64-bit x64 Standard Windows Server 2008 64-bit x64 Standard without Hyper-V1 Windows Server 2008 64-bit x64 Datacenter Windows Server 2008 64-bit x64 Datacenter without Hyper-V1 Windows Server 2008 64-bit x64 Enterprise Windows Server 2008 64-bit x64 Enterprise without Hyper-V1 Windows XP Embedded SP2 feature pack 20072 Windows Embedded for Point of Service SP22 Windows 7 Ultimate4 Windows 7 Home Basic4 Windows 7 Home Premium4 Windows 7 Enterprise4 Windows 7 Professional4 Windows 7 64-bit x64 Ultimate1,4 Windows 7 64-bit x64 Home Basic1,4 Windows 7 64-bit x64 Home Premium1,4 Windows 7 64-bit x64 Enterprise1,4 Windows 7 64-bit x64 Professional1,4 Windows Server 2008 R2 64-bit x64 Web1,4 Windows Server 2008 R2 64-bit x64 Foundation1,4 Windows Server 2008 R2 64-bit x64 Standard1,4 Windows Server 2008 R2 64-bit x64 Enterprise1,4 Windows Server 2008 R2 64-bit x64 Datacenter1,4
Memory	RAM: Minimum: 256 MB for SQL Server Express Minimum: 512 MB for SQL Server Express with Tools, and SQL Server Express with Advanced Services Recommended: 1.024 GB Maximum: 1 GB for the Database Engine that installs with SQL Server Express, SQL Server Express with Tools, and SQL Server Express with Advanced Services, 4 GB for Reporting Services that installs with SQL Server Express with Advanced Services

1This edition of SQL Server 2008 can be installed to the Windows on Windows (WOW64) 32-bit subsystem of a 64-bit server.

2Supports SQL Server 2008 Express, not SQL Server 2008 Express with Tools and SQL Server 2008 Express with Advanced Services.

3with Tools and with Advanced Services can be installed to the Windows on Windows (WOW64) 32-bit subsystem of a 64-bit server with this operating system.

4Supported only on SQL Server SP1 or higher for SQL Server 2008 Express with Tools and SQL Server 2008 Express with Advanced Services.

Note

SQL Server 2008 support on Windows Server 2003 R2 is the same as support on Windows Server 2003 SP2.

Note

SQL Server 2008 is not supported on Windows Server 2008 and Windows Server 2008 R2 Server Core installations.

SQL Server 2008 Express x64 (64-bit)

The following table shows system requirements for SQL Server 2008 Express x64 (64-bit):

Component	Requirement
Processor	Processor type: Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support Processor speed: Minimum: 1.4 GHz Recommended: 2.0 GHz or faster
Operating System	Windows Server 2003 x64 Windows Server 2003 SP2 64-bit x64 Standard1 Windows Server 2003 SP2 64-bit x64 Datacenter Windows Server 2003 SP2 64-bit x64 Enterprise1 Windows Vista Ultimate x64 Windows Vista Home Premium x64 Windows Vista Home Basic x64 Windows Vista Enterprise x64 Windows Vista Business x64 Windows Server 2008 64-bit x64 Web1 Windows Server 2008 64-bit x64 Standard Windows Server 2008 64-bit x64 Standard without Hyper-V1 Windows Server 2008 64-bit x64 Datacenter Windows Server 2008 64-bit x64 Datacenter without Hyper-V1 Windows Server 2008 64-bit x64 Enterprise Windows Server 2008 64-bit x64 Enterprise without Hyper-V1 Windows 7 64-bit x64 Ultimate Windows 7 64-bit x64 Home Basic Windows 7 64-bit x64 Home Premium Windows 7 64-bit x64 Enterprise Windows 7 64-bit x64 Professional Windows Server 2008 R2 64-bit x64 Web1 Windows Server 2008 R2 64-bit x64 Foundation Server1 Windows Server 2008 R2 64-bit x64 Standard1 Windows Server 2008 R2 64-bit x64 Enterprise1 Windows Server 2008 R2 64-bit x64 Datacenter1
Memory	RAM: Minimum:256 MB Recommended: 1.024 GB Maximum: 1 GB for the Database Engine

Note

SQL Server 2008 is not supported on Windows Server 2008 Server Core installations.

Cross-Language Support

The English-language version of SQL Server 2008 is supported on all localized versions of supported operating systems.
Localized versions of SQL Server 2008 are supported on localized operating systems that are the same language as the localized SQL Server 2008 version.
Localized versions of SQL Server can be upgraded to localized versions of SQL Server 2008 of the same language.
Localized versions of SQL Server cannot be upgraded to the English-language version of SQL Server 2008.
Localized versions of SQL Server cannot be upgraded to localized SQL Server 2008 versions of a different localized language.
Localized versions of SQL Server 2008 are also supported on English-language versions of supported operating systems by using the Windows Multilingual User Interface Pack (MUI) settings. However, you must verify certain operating system settings before you install a localized version of SQL Server 2008 on a server that is running an English-language operating system with a non-English MUI setting. You must verify that the following operating system settings match the language of SQL Server 2008 to be installed:
- The operating system user interface setting
- The operating system user locale setting
- The system locale setting

If these operating system settings do not match the language of the localized SQL Server, then you must correctly set these operating system settings before you install SQL Server 2008.

Extended System Support

SQL Server 2008 64-bit versions include support for extended systems, also known as Windows on Windows (WOW64). WOW64 is a feature of 64-bit editions of Windows that enables 32-bit applications to execute natively in 32-bit mode. Applications function in 32-bit mode even though the underlying operating system is running on the 64-bit operating system.

Hard Disk Space Requirements (32-Bit and 64-Bit)

During installation of SQL Server 2008, Windows Installer creates temporary files on the system drive. Before you run Setup to install or upgrade SQL Server, verify that you have at least 2.0 GB of available disk space on the system drive for these files. This requirement applies even if you install SQL Server components to a non-default drive.

Actual hard disk space requirements depend on your system configuration and the features that you decide to install. The following table provides disk space requirements for SQL Server 2008 components:

Feature	Disk space requirement
Database Engine and data files, Replication, and Full-Text Search	280 MB
Analysis Services and data files	90 MB
Reporting Services and Report Manager	120 MB
Integration Services	120 MB
Client Components	850 MB
SQL Server Books Online and SQL Server Compact Books Online	240 MB

Installing SQL Server on a Domain Controller

For security reasons, Microsoft recommends that you do not install SQL Server 2008 on a domain controller. SQL Server Setup will not block installation on a computer that is a domain controller, but the following limitations apply:

On Windows Server 2003, SQL Server services can run under a domain account or a local system account.
You cannot run SQL Server services on a domain controller under a local service account or a network service account.
After SQL Server is installed on a computer, you cannot change the computer from a domain member to a domain controller. You must uninstall SQL Server before you change the host computer to a domain controller.
After SQL Server is installed on a computer, you cannot change the computer from a domain controller to a domain member. You must uninstall SQL Server before you change the host computer to a domain member.
SQL Server failover cluster instances are not supported where cluster nodes are domain controllers.
SQL Server Setup cannot create security groups or provision SQL Server service accounts on a read-only domain controller. In this scenario, Setup will fail.

Supported Clients (64-Bit)

SQL Server 2008 64-bit client components can be installed on Windows Server 2003 (64-bit).

Stay Up to Date with SQL Server Install, and Upgrade information

For the latest downloads, articles, videos and troubleshooting information from Microsoft, as well as selected solutions from the community, visit the SQL Server Setup page

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Find Processes causing Locks on MS SQL DBs

March 21, 2012 gunnalag Leave a comment

MS SQL provides a Stored Procedure (SP) named sp_who2 which will show up all the actions going on on the MS SQL DB server as shown below:

You can have a temporary DB created with data from sp_who2 for your further processing as shown below

– check if there is a table already existing with the name
– you have choosen for your temp DB, if exists delete it
if OBJECT_ID(‘tempdb..#temp_spwho’) > 0 drop table #temp_spwho
go

– create new table with required fields of sp_who2
create table #temp_spwho (
     SPID int not null,
     Status varchar (255) not null,
     Login varchar (255) not null,
     HostName varchar (255) not null,
     BlkBy varchar(10) not null,
     DBName varchar (255) null,
     Command varchar (255) not null,
     CPUTime int not null,
     DiskIO int not null,
     LastBatch varchar (255) not null,
     ProgramName varchar (255) null,
     SPID2 int not null,
     RequestedBy int not null
)
go

– fetch the sp_who2 results into temporary table for processing
insert #temp_spwho exec sp_who2
go

– Show the rows whose SPIDs > 50 and BlkBy is NOT ‘ . ‘
select * from #temp_spwho where SPID > 50 and BlkBy != ‘ . ‘ order by LastBatch desc
go

– delete the temp DB
if OBJECT_ID(‘tempdb..#temp_spwho’) > 0 drop table #temp_spwho

To further analyze what a given process is doing, you can check via below command:

DBCC inputbuffer (<SPID>)

Categories: DataBase

How to attach/detach a database without Enterprise Manager?

February 27, 2012 gunnalag Leave a comment

Introduction:

Due to various reasons it can be possible that the Enterprise Manager cannot be used to attach/detach a database in SQL. For example when the MSDE version of SQL is used, the Enterprise Manager is not available. In this case MS-Dos can be used to attach/detach the database.

Explanation:

In order to attach/detach a database via MS-Dos follow the steps below:

Go to [Start] [Run] and type CMD followed by [Enter]
type cd\ [Enter] to go to the root C:\
type osql -E [Enter]
now, 1> will appear. The commandline can now be entered.

Attach a database:

In the commandline type sp_attach_db ‘databasename’,'C:\path to databases\database.mdf’,'C:\path to databases\database.ldf’ [Enter]
In the second line type go [Enter]
Now if no message appears the database has been attached succesfully!

Detach a database:

In the commandline type sp_detach_db ‘databasename’
In the second line type go [Enter]
Now if no message appears the database has been detached succesfully!

Source: How to attach/detach a database without Enterprise Manager?

Categories: DataBase

Error: Another Version of Microsoft Visual Studio 2008 has been Detected on this System that must be Updated to SP1

February 27, 2012 gunnalag Leave a comment

Symptoms

While attempting to install the SQL database and management tools from Microsoft on Windows 2008 R2 server that has XenApp 6.0 or later version installed, the following error message appears:

“Another version of Microsoft Visual Studio 2008 has been detected on this system that must be updated to SP1. Please update all Visual Studio 2008 installations to SP1 level, by visiting Microsoft update.”

The following table provides information about where the installation of SQL 2008 database and management tools fails.

Machine Type	SQL 2008 database and management tools: Install
XenApp Installed, Configured on Windows 2008 R2 using SQL Express as data store	Fails
XenApp Installed, Configured on Windows 2008 R2 using SQL Enterprise as data store	Fails
XenApp Installed, NOT Configured on Windows 2008 R2	Fails
Clean Windows 2008 R2 with no XenApp installed	Success

Resolution

Citrix recommends that the SQL database and management tools be installed on a machine that does not have XenApp installed. Once the database and management tools have been installed, connect to the specific database instance by using the Microsoft SQL Server Management Studio, as displayed in the following screen shot:

Alternative installation:

Once XenApp 6.0 is installed, run the following command:

msiexec /i D:\x64\Setup\vs_shell.msi PATCH=D:\x64\Setup\VS90sp1-KB945140.msp /qb (where D:\ is the location of your SQL media)

The other known workaround to get the SQL database and management tools installed on the same computer which is running XenApp 6.0 or later is to use the following registry edit.

Caution! This fix requires you to edit the registry. Using Registry Editor incorrectly can cause serious problems that might require you to reinstall your operating system. Citrix cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk. Be sure to back up the registry before you edit it

1. Open the Registry on XenApp machine using Start > Run > Regedit.

2. Browse for HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS

3. Rename this key to VS_1 or something similar.

4. Install the SQL database and management tools.

5. Rename
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS_1
to
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS

6. Restart.

7. Go to Start > All programs > Microsoft SQL Server 2008 > SQL Server Management Studio and connect to your database instance, as shown in the following screen shot:

This document applies to:

· XenApp 5.0 for Windows Server 2008 x64

· XenApp 5.0 for Windows Server 2008 x86

· XenApp 6.0 for Windows Server 2008 R2

Source: CTX128280 – Error: Another Version of Microsoft Visual Studio 2008 has been Detected on this System that must be Updated to SP1 – Citrix Knowledge Center

Categories: Citrix, DataBase

How to kill all sessions that have open connection in a SQL Server Database?

February 27, 2012 gunnalag Leave a comment

As SQL Server DBAs, many times we need to KILL all Open Sessions against the SQL Server Database to proceed with Maintenance Task, Restore and more…

You can use below different techniques to KILL all open sessions against the database.

Technique – I
Here we will query the SysProcesses table to get the session running against the user database and prepare the dynamic SQL statement to KILL all the connection.

view source

print ?

01	DECLARE @DbName nvarchar(50)
02	SET @DbName = N’Write a DB Name here’

03
04	DECLARE @EXECSQL varchar(max)

05	SET @EXECSQL = ”
06

07	SELECT @EXECSQL = @EXECSQL + ‘Kill ‘ + Convert(varchar, SPId) + ‘;’
08	FROM MASTER..SysProcesses

09	WHERE DBId = DB_ID(@DbName) AND SPId @@SPId
10

11	EXEC(@EXECSQL)

Technique – II
Take the database into Single User Mode and execute all the task needs to perform against the databse.

view source

print ?

1	ALTER DATABASE [Database Name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Once you are finish with all the required task make the database accessible to everyone.

view source

print ?

1	ALTER DATABASE [Database Name] SET MULTI_USER

Technique – III
In case of restore the database by replacing existing database, you can take the database OFFLINE and restore it. Restore will bring the database online.

view source

print ?

1	ALTER DATABASE [Database Name] SET OFFLINE WITH ROLLBACK IMMEDIATE

view source

print ?

1	ALTER DATABASE [Database Name] SET ONLINE

Technique – IV
Go to Activity Monitor, Select the desired database and right click on the database to KILL the process.

Source: How to kill all sessions that have open connection in a SQL Server Database? « SQLDBPOOL.COM

Categories: DataBase

Fix: Cannot detach the database ‘DBName’ because it is currently in use. (Microsoft SQL Server, Error: 3703)

February 27, 2012 gunnalag Leave a comment

When you detach a SQL DB via script/programmatic way you notice SQL fails to detach the DB with error indicating that the DB is still in use. The same DB detach just works fine when you manually detach the DB before attempting to do it via scripted way. Once scripting fails, even manual detach fails including restarting the SQL server instance service fails to get the DB released.

This scenario particularly exists while you are copying/duplicating/restoring the DB on the SQL server instance.

Error:

TITLE: Microsoft SQL Server Management Studio

——————————

Detach database failed for Server ‘TESTSRV2008R2\MyDB’. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0038+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Detach+database+Server&LinkId=20476

——————————

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

——————————

Cannot detach the database ‘MyDB’ because it is currently in use. (Microsoft SQL Server, Error: 3703)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500&EvtSrc=MSSQLServer&EvtID=3703&LinkId=20476

——————————

BUTTONS:

——————————

Cause and Troubleshooting:

You don’t understand which process is holding the DB in-use. Further to that killing the respective accessing DB processes even won’t help you. Forcing DB detach/delete with ‘end/close existing connections’ leaves DB in Single user mode.

select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame

from sysprocesses p inner join sysdatabases d on p.dbid = d.dbid

where d.name like ‘%mydb%’

go

kill 53

go

Fix:

The fix is to make the DB offline with ‘SET OFFLINE WITH ROLLBACK IMMEDIATE’ setting so that the DB will turn offline immediately and then Detach DB will work fine. When you attach the DB you can make the DB Online.

ALTER DATABASE <DBName> SET OFFLINE WITH ROLLBACK IMMEDIATE

ALTER DATABASE [Database Name] SET ONLINE

References:

Categories: DataBase

SQL Queries: Capturing changes to DB, Analyzing the changes

February 3, 2012 gunnalag Leave a comment

Backing up default tables:

Select * Into USERS_Backup from USERS

(6 row(s) affected)

Duplicating Rows:

INSERT into [USERS] SELECT * from [USERS] where [USERNAME] = ‘DEMO’

Msg 2601, Level 14, State 1, Line 1

Cannot insert duplicate key row in object ‘dbo.USERS’ with unique index ‘USRRECID’. The duplicate key value is (PQ$&3-#5U1).

The statement has been terminated.

Modifying existing rows:

UPDATE [MYDB].[dbo].[USERS]
SET [USERNAME] = ‘DEMO’,
[NAME] = ‘DEMO’
WHERE USERNAME = ‘NEWDEMO’
GO

Creating new users:

SET ansi_warnings OFF
INSERT INTO [USERS] VALUES (‘TESTUSR1′,’TESTUSR1′,NULL,NULL,NULL,NULL,NULL,NULL,’0_’,'encryptedpasswordstringhere’,NULL,’TESTUSR1′,’2011-12-16 00:00:00.000′,’13:23′,NULL,”,’new-recid’)

Compare two tables having identical layout:

SQL Query:

SELECT * FROM CONTACT1 WHERE NOT EXISTS (SELECT * FROM CONTACT1_Backup WHERE CONTACT1_Backup.CONTACT = CONTACT1.CONTACT)

Results:

Categories: DataBase

The database ‘%.*ls’ cannot be opened because it is version %d. This server supports version %d and earlier. A downgrade path is not supported.

December 27, 2011 gunnalag Leave a comment

Details

Product:
SQL Server

ID:
948

Source:
MSSQLServer

Version:
10.0

Component:
SQLEngine

Message:
The database ‘%.*ls’ cannot be opened because it is version %d. This server supports version %d and earlier. A downgrade path is not supported.

Explanation

Certain features in SQL Server affect the structure of the database files. When you attach a database to another instance of SQL Server, the file format might not be compatible with a different version of the Database Engine.

For example, this error can be caused by using the vardecimal storage format in a later version of SQL Server and then trying to attach the database files in a version earlier than SQL Server 2005 Service Pack 2.

User Action

Determine the version of SQL Server that is running on the originating server. In SQL Server Management Studio, either right-click the server and then click Properties or type SELECT @@VERSION in a query window. Open the database by using the original version of SQL Server. Investigate the features that are enabled on the original database in the instance of SQL Server. Modify these settings to work with the version of SQL Server in which the database will be attached.

Version:
9.0

Component:
SQLEngine

Message:
The database ‘%.*ls’ cannot be opened because it is version %d. This server supports version %d and earlier. A downgrade path is not supported.

Explanation

For example, this error can be caused by using the vardecimal data type in a later version of SQL Server and then trying to attach the database files in a version earlier than SQL Server 2005 Service Pack 2.

User Action

Source: MSSQLServer ID: 948 (SQL Server ) – Events And Errors Message Center: Message Details

Categories: DataBase

SQL Query to get the MS SQL server version

December 27, 2011 gunnalag Leave a comment

SQL Query:

SELECT @@VERSION

Results:

(No column name)

Microsoft SQL Server 2008 (SP3) – 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

Categories: DataBase

Older Entries

LICSaving

Avail 25% discount on first premium which you are paying

Jeevan saral

invest mtly 2000 / 20 years get 1602960/- for 20 years you are investing 2000*12*20 =4800000 but you are getting 1602960 i.e 4 times of amount

Can Avail Loan on Premium amount paid
Avial 250 times monthly premium risk amount
partial withdrawals after 10 years
can surrender at any time
without any surrender penalty or loss after 5 years
unique policy cover child education,marraige,your pension req

Premiun can opt Mtlhy / QTLY / HFLY / YLY
for more info Call Anil kumar vulli
8500720335 / avulli@licsaving.in

Govardhan Gunnala

Archive

Hardware and Software Requirements for Installing SQL Server 2012

Hardware and Software Requirements for Installing SQL Server 2008

Find Processes causing Locks on MS SQL DBs

How to attach/detach a database without Enterprise Manager?

Introduction:

Explanation:

Attach a database:

Detach a database:

Error: Another Version of Microsoft Visual Studio 2008 has been Detected on this System that must be Updated to SP1

How to kill all sessions that have open connection in a SQL Server Database?

Fix: Cannot detach the database ‘DBName’ because it is currently in use. (Microsoft SQL Server, Error: 3703)

SQL Queries: Capturing changes to DB, Analyzing the changes

The database ‘%.*ls’ cannot be opened because it is version %d. This server supports version %d and earlier. A downgrade path is not supported.

SQL Query to get the MS SQL server version

Email Subscription

Site Views

LICSaving

Avail 25% discount on first premium which you are paying

Jeevan saral

Top Clicks

Top Rated

Latest Tweets

My Google Feed Bundles

Calendar

Categories

Archives

Follow “Govardhan Gunnala”