Overview of 64bit SQL

,

Microsoft® SQL Server™ 2000 Enterprise Edition (64-bit) provides full native

support for the 64-bit version of the Microsoft Windows® operating system

running on Intel Itanium Processors. This version of SQL Server 2000 provides

many of the features of the 32-bit version, as well as providing support for

64-bit hardware. The 64-bit versions of Windows SQL Server 2000 and SQL Server

2000 Enterprise Edition combine to form a massive datacenter power plant capable

of tackling today's most demanding database needs as well as future industry

trends. It supports four languages: English, German, Japanese, and French.

Why 64-Bit Environment

The need for 64-bit technology is driven by applications that require high

performance and address large amounts of physical and virtual memory.

Enterprises need 64-bit systems as they offer greater power, reliability and

scalability. Primarily, a 64-bit machine can address more memory directly

without using complex indexing or register-addressing schemes. Because internal

memory is several orders of magnitude faster than storage, combining a 64-bit

processing architecture with more RAM lets a processor pull more data into

memory and operate on it directly, increasing performance manifold.

A 64-bit file system also can improve disk management. Rather than having to

take a large disk, such as a 9 GB storage module, and segmenting it into 32-bit

addressable chunks (2 GB each), you can address the entire disk. That can help,

for example, in both database performance and the performance of the operating

system itself.

The move to 64 bits will primarily help users who need to access very large

data stores. This category includes applications such as CAD/CAM, science and

engineering, human resources, online analytical processing (OLAP) and financial

modeling. Users working with these computer-intensive applications will probably

see immediate improvement with 64-bit machines over 32-bit machines running at

the same clock rate and with similar memory configurations.

Product Highlights

Optimized to run on Itanium-based servers and Microsoft Windows® Server 2003,

SQL Server 2000 Enterprise Edition (64-bit) delivers exceptional performance,

reliability, and scalability; easy migration; and total cost of ownership (TCO)

advantages for today's most demanding enterprise workloads.

Built to take advantage of hardware enhancements of the new breed of 64-bit

servers, SQL Server 2000 Enterprise Edition (64-bit) offers higher levels of

single-system scalability (scale-up) for the most memory-intensive data

applications.

No longer, bound by the 32-bit memory limit of four gigabytes (GB), SQL Server

2000 (64-bit) is able to perform complex queries on large data sets without

performance loss. Direct utilization of additional memory is made available to

the system to use for essential database resources in order to increase

throughput and performance. By expanding the headroom necessary to access large

amounts of data and to support large numbers of concurrent database users and

client applications, SQL Server 2000 (64-bit) enables new levels of scalability

for enterprise applications.

There are application performance improvements through enhanced mathematic

computational ability. The server can handle an increased number of users and

connections through increases in memory capacity and it supports faster

processors and parallel processing. These enhancements provide additional

performance, scalability, and reliability for memory-intensive applications and

workloads.

This definitely breaks the 4-gigabyte (GB)/64-GB memory limit of the 32-bit

platform, based on the OS version. With the 64-bit platform, the operating

system now supports more than 64 GB of physical and virtual memory. It also

supports very large virtual memory, in the range of 16 terabytes.

Hardware error detection and prediction increases hardware reliability.

Correctable and non-correctable errors are now reported in the event log. This

allows the user to easily determine the exact cause of any hardware failure. The

new hardware error detection, prediction, error checking, and notifications

increase hardware reliability. This, in turn, increases reliability and

availability of the 64-bit SQL Server 2000.

Compatibility with Existing SQL Server Installations

SQL Server 2000 Enterprise Edition (64-bit) ships a 64-bit database server, a

64-bit server agent, and a 64-bit analysis server with online analytical

processing (OLAP) and data mining. These components of SQL Server 2000

Enterprise Edition (64-bit) are code compatible with the 32-bit version of SQL

Server 2000, making it easy to integrate a 64-bit server with other SQL Server

2000 (32-bit) database servers. For database management and administration,

32-bit clients and SQL Server tools such as SQL Server Enterprise Manager and

SQL Query Analyzer are easily used to remotely manage a SQL Server 2000

Enterprise Edition (64-bit) database.

Easy Migration from a 32-Bit SQL Server 2000 Database

By maintaining the same on-disk format on both 32-bit and 64-bit platforms,

database administrators are able to protect key database investments made

previously on a 32-bit server, easily moving user databases over to the new

platform with minimal conversion effort. Migration is as easy as detaching the

32-bit database using a system- supplied stored procedure, transferring the user

database to the 64-bit server’s disk sub-system, and attaching it to the 64-bit

database server, again using a system- supplied stored procedure.

Client-Access Compatibility

Client applications that currently access SQL Server 2000 (32-bit) are able

to easily connect to and access SQL Server 2000 (64-bit) without changes to

application code. SQL Server 2000 (64-bit) supports client- access technology

such as Microsoft ActiveX® Data Objects (ADO) and OLE DB, and maintains complete

Transact-SQL code compatibility with the 32-bit version.

A Scalable Platform for Business Intelligence

Aggregating data acquired from multiple sources and adding them to the data

warehouse is critical for providing enterprises with the ability to answer

business analysis questions. With the ability of SQL Server 2000 (64-bit) to

address additional memory on a single 64-bit server, complex dimension

structures can now be stored in memory to analyze a large amount of data. Cube

processing and cube querying are also enhanced by access to larger memory

resources for caching, faster processing, and deeper analysis.

Support for High-Availability Configurations

SQL Server 2000 (64-bit) supports up to eight nodes in a failover cluster,

enabling more complex high availability configurations. By allowing other 64-bit

servers to back up critical applications in the event of planned or unplanned

downtime, business operations are more protected and business applications are

continuously available.

A Robust Platform for Server Consolidation

With the significant increase in memory capacity on 64-bit systems,

enterprises now have an enhanced platform to consolidate their databases and

database servers, requiring fewer machines to serve larger amounts of data. The

ability of 64-bit hardware to support multiple processors also enables

organizations to consolidate applications on fewer physical machines, each

supported by SQL Server 2000 (64-bit).

The Choice for Your Enterprise Database Requirements

SQL Server 2000 Enterprise Edition (64-bit) scales to meet the demanding

requirements of today's enterprises. Capable of addressing complex computations

involving massive amounts of data processing, from data warehouse applications

to natural science simulation applications, SQL Server 2000 Enterprise Edition

(64-bit) provides the data management horsepower necessary for high-end

enterprise applications. You now have the choice to implement your enterprise

applications on SQL Server 2000 Enterprise Edition (64-bit), providing better

performance and total cost of ownership compared to Unix-based database

offerings. With database sizes rapidly increasing, SQL Server 2000 (64-bit)

helps you to build and sustain a strategic advantage by efficiently managing

your corporate data assets and keeping your company agile and responsive in

today’s competitive market.

Addressing Industry Trends

Without question, the initial target market for SQL Server 2000 (64-bit) is

the portion of the application market that requires memory-intensive workloads.

The majority of these applications can be found in the following areas:

  • Data warehousing, data analysis, and decision support systems
  • Global-scale Web services
  • E-commerce applications with an unbounded number of users
  • Statistical modeling and analysis
  • Geo-spatial applications
  • Hosting scenarios

Today large database management, data mining, and decision support systems

can benefit the most from adopting 64-bit Itanium 2-based systems, based on

recent industry trends. Certain applications need to exceed the 4-GB address

space limitation of 32-bit systems. An example is a database application,

particularly those from data mining, memory-intensive workload, or an

I/O-intensive workload applications. These three trends are among the top forces

that drive our industry toward this next level of scalability:

  • Applications and data are growing in complexity and size. The size and

    complexity of applications and data continue to grow at an accelerated rate.

    Companies representing various industries are reporting that their databases

    are doubling in size every 9 to 15 months. Search the Web, poll the

    progressive companies today, and you will begin to see the rising number of

    customers whose database sizes are doubling. The current trend of

    improvements on processors is stated by the updated Moore's law, which now

    says, "Processor speed is doubling roughly every 18 months." 64-bit

    technology is intended to help the hardware industry keep up with the

    constant demand for more power.

  • High-end DBMS is becoming a requirement. As size and complexity of

    applications increase so do the demands on the database in the application.

    A rapidly increasing number of enterprise business and technical

    applications today are requiring a high-end data management platform that

    can meet the twin demands of high concurrency and scalable data management

    due to the breakneck rate at which they are amassing business data.

    Companies are seeing a significant increase in the size of databases in

    their organization, rapidly growing to extremely large dimensions.

  • Datacenters are consolidating. Limitations exist in both speed and

    physical space. Based on more than just the desire to save space, datacenter

    consolidation efforts have become popular in an effort to reduce the number

    of machines and associated management complexity and management cost.

As these industry trends begin to take shape, we will see other areas where

SQL Server 2000 (64-bit) makes sense. One area that will eventually catch on is

the value that 64-bit technology brings to the consolidation effort. Hardware

vendors are in the process of releasing 64-bit computers that support up to 64

processors and theoretical limits of 32 TB of addressable memory. (At the time

of this writing only 256 GB of memory is available on servers, but the industry

is on track to support higher memory configurations within the next few months.)

These servers will deliver a tremendous amount of processing power in a small

footprint. SQL Server 2000 (64-bit) can provide native support for these servers

at the same database price point as the 32-bit product. ISVs will eventually

want to upgrade to 64-bit in an effort to help their customers achieve maximum

headroom for large databases as well as maximum performance and scalability for

common databases.

Migration Benefits

A migration from one version of software to another is typically no trivial

matter. A great deal of planning is involved. Migration plans in general require

costly consulting time, staff augmentation, and training. For the customer this

inherent complexity was reduced with the migration from SQL Server 2000 (32-bit)

to SQL Server (64-bit), because of the key compatibilities of the two platforms.

Benefits in the Migration Process

Migrating from a 32-bit version to a 64-bit version of SQL Server is neither

difficult nor time-consuming. In fact, the process looks identical to a

migration from one 32-bit SQL database to another. Because of the technical

simplicity of a migration from a 32-bit version to a 64-bit version of SQL

Server, building a migration strategy turns into a database targeting effort.

The information provided in this white paper will be useful for the ISV, DBA,

and developer communities to begin targeting specific databases that can benefit

from 64-bit technology.

Deployment Benefits

SQL Server 2000 (64-bit) is a database product created by recompiling the SQL

Server 2000 code base for the Itanium 2-based platform using the latest 64-bit

compilers for Windows Server 2003. When migrating a database, the front-end

application does not experience any difference other than performance. The

database administrator can literally migrate databases one by one, without any

modification to the client.

Licensing Benefits

Microsoft has designed the pricing and licensing of SQL Server 2000 (64-bit)

to remain the same as its 32-bit counterpart. This allows customers to continue

to benefit from the various licensing programs without having to rebudget new

server deployments due to new or higher costs. For more details on licensing SQL

Server 2000 (64-bit), visit the www.microsoft.com/sql/64-bit Web site.

Operational Benefits

The 32-bit and 64-bit versions of SQL Server are very similar. However, there

are a few improvements to SQL Server 2000 (64-bit) as well as some inherited

functionality from the 32-bit version that prove beneficial from the standpoint

of day-to-day operations.

Maintenance Benefits

Microsoft Data Access Components (MDAC). MDAC is now managed by the

underlying operating system, removing this responsibility from the DBA. Reducing

the number of physical database servers to manage. Reducing the number of

physical database servers was a big gain for the customer, not just in the area

of datacenter consolidation, but also for maintenance and management costs. The

price per application and the associated costs of maintaining multiple database

servers began to drop as new database requirements were met with much less

effort and expense.

On-Disk Format Benefits

Along with memory-intensive and performance-critical applications, SQL Server

2000 (64-bit) meets the demand for extremely large databases. The 64-bit version

inherits the advanced on-disk database format from the 32-bit version which was

designed to handle database sizes into the terabyte range. SQL Server 2000

(64-bit) will support ever-expanding amount of customer data.

Cluster Services Benefits

SQL Server 2000 (64-bit) provides the option to implement the application

architecture on a failover cluster to provide high system and application

availability.

Windows Installer-Based

SQL Server 2000 (64-bit) uses the Windows Installer to completely integrate

the installation of SQL Server features in a single feature tree. Minimum and

typical installation modes are no longer implemented. Setup initially displays

the feature tree with all available features selected. Administrators can

customize installations by choosing items on the feature tree and changing

installation paths.

Setup Feature Tree Interaction with Parent/Child Features

In this release of SQL Server 2000 (64-bit), child feature selection is more

limited than in the 32-bit version of SQL Server 2000. For example, the Tools

feature installs all tools; there is no option to select individual tools.

Similarly, Server Components are limited to SQL Server and the Full-Text Search

Engine. The full selection of child features will be enabled in the next major

release.

Connectivity-Only Option Not Supported

The Connectivity-Only option is not implemented during the SQL Server 2000

(64-bit) Setup. The Connectivity-Only option in previous versions installed

Microsoft Data Access Components (MDAC) and JET. JET is not available for the

64-bit version of SQL Server 2000. MDAC 64-bit components are installed by the

64-bit versions of the Windows® Server 2003 family as part of its core

components.

Remote Installation

SQL Server 2000 (64-bit) does not support remote installation.

Previous Version Upgrades

Previous versions of SQL Server for the 32-bit computer are not supported to

run on the 64-bit platform; upgrades of 32-bit instances are not supported in

this release.

Data Migration

Data migration from SQL Server 2000 to SQL Server 2000 (64-bit) is supported.

Attaching a 32-bit database to a 64-bit instance is possible by using

detach/attach or backup/restore in 32-bit Enterprise Manager. You can move

databases back and forth between 32-bit and 64-bit versions of SQL Server.

Migrating data from SQL Server version 7.0 is also supported using the same

methods. Downgrading data to SQL Server 7.0 from SQL Server 2000 (64-bit) is not

supported.

Feature Maintenance

SQL Server 2000 (64-bit) uses Add or Remove Programs in Control Panel to

fully support the addition and removal of individual features, as well as to

remove instances of SQL Server. You can also use the Setup user interface or

command line for installation maintenance. Feature maintenance for clustered

installations is not supported.

Instance Maintenance

Maintenance activities on existing installations are supported with Add or

Remove Programs in Control Panel as well as by the Setup program. Each installed

instance (except for clustered installations) is listed in the Add or Remove

Programs dialog box. Any non-cluster instance may be removed or changed with the

Add or Remove Programs. Instance maintenance may also be performed on the setup

command line by specifying features on the command line or in an .ini file. For

information about cluster maintenance, see the section on failover clustering at

the end of this topic.

Network Libraries

The Network Library configuration page is not included in SQL Server 2000

(64-bit). Setup initially enables Shared Memory, Named Pipes, and TCP/IP. Use

the SQL Server Network Utility to change the settings that enable or disable

protocols. Configuration of Network Libraries is not supported in Setup, but is

still supported by the SQL Server Network Utility. Configure client network

libraries using the Client Network Utility (cliconfg.exe) included with the

64-bit versions of the Windows Server 2003 family.

Services

The Service Account dialog supports the SQL Server Service (MSSQLSERVER,

MSSQL$<instancename>), the SQL Agent Service (SQLSERVERAGENT, SQLAgent$<instancename>),

and the Analysis Services (MSSQLServerOLAPService) account. The Remote Account

Information dialog supports the Cluster Setup Admin account for use when

installing a virtual server. Command-line support for configuration of these

accounts is also provided.

Analysis Services Integrated into SQL Server Setup

Analysis Services can be installed at the same time as the SQL Server

relational database engine and other SQL Server components. It is part of the

Windows Installer feature tree, in which you can select the features you want to

include in your installation. Analysis Services appears in the feature tree with

Data and SQL Repository child features.

Analysis Services Uses the SQL Server Repository

The 64-bit version of Analysis Services uses SQL Server instead of Jet (.MDB)

for its meta data repository. If the full SQL Server is not installed with

Analysis Services, the SQL Repository child feature installs the core SQL Server

files and enables you to specify the location of these files

Graphical User Interface Management Tools

To administer a 64-bit SQL Server or Analysis Server with management tools

like Enterprise Manager or Analysis Manager, you must use the 32-bit tools on a

32-bit server to remotely administer the 64-bit server. The only 64-bit tools

included with this release are the Server Network Utility, the Service Manager,

and the command line utilities.

Distributed Transaction Coordinator (DTC) Installed with the 64-bit versions

of the Windows Server 2003 family

DTC is part of the 64-bit versions of the Windows Server 2003 family

operating system and is no longer installed as part of the SQL Server 2000

(64-bit) setup. The DTC service can no longer be managed from the SQL Server

Service Manager. To manage this service, use Services in the 64-bit versions of

the Windows Server 2003 family Administrative Tools.

Data Transformation Services (DTS) components for 64-bit servers are not

available in this release. Note the resulting functionality changes:

  • A DTS package can be saved on the 64-bit server, and a DTS package can

    be run against a SQL Server 2000 (64-bit) dataset, but the package must run

    from a 32-bit machine that is set up with SQL Server 2000 tools.

  • The Copy Database Wizard will not be able to run on a 64-bit server or

    target a 64-bit server. Data migration from SQL Server 2000 to SQL Server

    2000 (64-bit) is supported. Attaching a 32-bit database to a 64-bit instance

    is possible by using either the detach/attach or the backup/restore

    technique. You can move databases back and forth between 32-bit and 64-bit

    versions of SQL Server.

  • If you are using Meta Data Services (MDS) to store a DTS package, you

    must manage and store the DTS package on a 32-bit server.

  • Transformable push subscriptions are not supported. Pull subscriptions

    from a 32-bit installation of SQL Server 2000 should work with a 64-bit

    Publisher or Distributor.

  • CDW, also known as Copy Database Wizard, is also not available, because

    the needed DTS components are not available on the 64-bit platform.

SQL Mail

SQL Mail is not available on 64-bit SQL Server 2000. However, SQL Server

Agent mail is supported. SQL Agent Mail in the 64-bit SQL Server can be

configured remotely through Enterprise Manager if your client remotely connects

using SQL Server 2000 Service Pack 3 or later. To configure SQL Agent mail, you

must use Microsoft Outlook® Express. If you already have an SMTP Outlook Express

profile created, you can use that profile for SQL Agent Mail by setting it up as

a default account. The tools included are Network Utility, the Service Manger,

and command-line utilities. To access the 64-bit version of management tools

such as Enterprise Manager and Analysis Manager, you must use 32-bit tools on a

32-bit platform to remotely administer the 64-bit server.

Capacity

SQL Server 64-bit can support up to eight-node clusters. The AWE option is

ignored because on this platform there is no practical memory limitation. You

can see this AWE configuration parameter, but it is ignored by the 64-bit

version of SQL Server 2000. A new option is added, affinity64 bit mask, and this

is used to configure the processor affinity mask for the top 32 CPUs on a system

that has more than 32 CPUs. A new startup option, -E, is added for file

allocation extension.

Installation and Setup

After a site has identified its need for 64-bit and targeted the databases,

the next task is to install SQL in preparation for the migration process. There

is very little difference from the 32-bit version when it comes to installation.

One of the biggest changes is the switch to Windows Installer. SQL Server 2000

(64-bit) now uses Windows Installer to completely integrate the installation of

SQL Server components in a single feature tree. Notice that Analysis Services is

no longer installed separately. The install procedure for SQL Server 2000

(64-bit) is very similar to that for the 32-bit version.

1. Insert the Microsoft SQL Server 2000 (64-bit) compact disc in your CD-ROM

drive. If you are installing from a network location, share the installation

folder and connect to the location from the computer where you want to install

the program.

2. In the root folder of the compact disc or installation location on the

network, double-click Setup.exe.

If a cluster is detected, Virtual server is the default selection. Otherwise,

Local Instance is the only selection available.

3. Click Next twice.

4. On the Registration Information page, enter the user name, company, and

product key, and then click Next.

5. On the Software License Agreement page, read the license agreement, and then

click Yes to accept the license agreement. (Clicking No ends Setup.)

6. On the Feature Selection page, select or remove the components to be

installed with SQL Server 2000.

7. To change how a feature is installed, click the icon to the left of the

feature and select a different option.

8. To change the installation path, click the feature and then click Browse.

However, you cannot change directories when Maintenance Mode is selected for a

SQL Server instance.

9. Click Disk Cost to view calculated disk cost before adding or removing SQL

Server components.

10. Click Next.

11. On the Instance Name page, you can choose to install either the default

instance or a named instance. Do one of the following:

    - To install the default instance, click Default instance,

and then click Next.

    - To install a named instance, click Named instance, type a

name for the instance, and then click Next.

If a default instance has already been installed, all additional SQL Server

instances on the machine must be named instances.

12. On the Service Account page, configure the logon account information for SQL

Server 2000 service accounts. Select Advanced to configure service accounts

separately.

13. On the Authentication Mode page, accept the default setting for Windows

Authentication.

Whenever possible, use Windows Authentication. If you want to use Mixed Mode,

click Help.

14. To identify the sa password, click Set an sa password, type and confirm your

password in the fields provided, and then click Next.

Important You can no longer set a blank sa password due to security

restrictions.

15. On the Cross-Database Ownership Chaining page, verify the cross-database

ownership chaining security enhancement, and then click Continue.

Note Cross-database ownership chaining is not recommended and is turned off by

default. However, after installation you can enable cross-database ownership

chaining for individual databases. If you must use cross-database ownership

chaining with all databases, select the check box. For security reasons,

Microsoft recommends that you do not enable cross-database ownership chaining

for all databases.

16. On the Collation Settings page, accept the default settings, and then click

Next. (If you need to match collation settings in instances of SQL Server or to

match the Windows locale of another computer, click Help instead.)

17. On the Error Reporting page, enable any error reporting you want for the SQL

Server relational database engine, SQL Server Agent, and SQL Server Analysis

Services, and then click Next.

18. On the Licensing Mode page, make selections according to your license

agreement, and then click Next. (For information about licensing, click Help

instead or see your system administrator.)

19. On the Ready to Install page, click Install to proceed with the

installation.

20. On the Completing the Microsoft SQL Server Installation Wizard page, click

Finish.

Log Files

When you run setup, log files are created in %TEMP% directory as sqlrunXX.log,

and the general information file is created as sqlstpXX.log. Please note that

sqlstpXX.log file is a general information file. The XX represents a enumerated

number here.

The user can create a manual verbose log file by using the command-line switch

/L*v. For example, if you want to create a verbose log file for your setup, at

the command prompt you can use a command like setup.exe /L*v c:\Logfile.txt.

This creates a manual verbose log file named Logfile.txt, it will put the log

file into the c:\root directory, and you can point it to any directory you want.

If a failure occurs, the quickest way to search the log is to find the first

instance of Return Value 3 and look at what the output says.

Unattended Setup Parameters

Unattended setup is better because it has fewer command-line switches. Now we

have /qb for quiet-mode with basic GUI, or you can use /qn for quiet mode with

no GUI. We can also use the /settings parameter if we're using a setting file.

You can always use setup.exe /? to find all the possible options, and it

explains what command-line options it uses for what.

All setup parameters can be specified on a command-line. However, a settings

file will make them easier to read and organize. To make things easier, a

Template.ini file is provided on your CD. When you receive the CD or you go to

the product CD, you will see the Template.ini file. This file explains each

setup option in detail and gives examples of the options to use. The file is

easy to create and easy to use to communicate exactly what you are installing or

what you want to install.

Please note that we suggest providing a password at the command line instead of

inside the Template.ini file. A Template.ini file exports its password in a .txt

format. So if you put a password in a Template.ini file, then I would suggest

that you remove the password after you have completed your setup.

Maintenance

For maintenance mode, Registry Rebuild and Rebuild Master are setup utilities

used to repair corrupted installation. Registry Rebuild allows the user to

repair the registry key associated with SQL Server. Rebuild Master allows the

user to rebuild a system database without uninstalling and installing SQL

Server. There are new options. The reinstall mode has two switches, omus or amus;

omus for Registry Rebuild and amus for Rebuild Master database

Management Tools

Administrative tools such as Enterprise Manager, Query Analyzer, DTS, and

Profiler can be used from a 32-bit computer to administer your 64-bit server.

Locally installed tools include Service Manager, Server Network Utility, Books

Online, Client Network Utility, and command- line tools such as OSQL, BCP,

sqldiag, and others used for replication

Troubleshooting

For setup issues, check the final status in the verbose log file. You can

create verbose log files manually at the command prompt using option /L*v.

Do_sqlscript replaces cnfgsvr.exe, which we had before in 32-bit SQL Server

2000.

In the verbose log file, if Return Value 1, it is good. For an error or

failure, search for Return Value 3 in the verbose log file. Identify the failed

custom action and the reason why. Because in the verbose log file of setup we

include the error reporting and error description to give you much more

information and also some pointers.

For a successful installation, check the log files for "Installation completed

successfully."

DTS components for 64-bit servers are not available in this release. DTS

packages can be saved on 64-bit servers, and DTS packages can be run on the SQL

Server 2000 64-bit dataset. But the package must be run from a 32-bit machine

that is set up with 32-bit SQL Server tools.

The Copy Database Wizard is not available on 64-bit servers or target 64-bit

servers. For data migration, you can use 32-bit SQL Server 2000 to 64-bit. You

can use backup or restore, or the detach/attach database techniques. If you are

using Meta Data Services to store the DTS package, you must manage and store the

DTS packages on a 32-bit server, because MDS is not available on 64-bit SQL

Server.

A linked server to a remote 32-bit SQL Server or remote 64-bit SQL Server

will work fine. To link the server to any other data source, you need a 64-bit

OLE DB provider from the vendor. Windows on Windows 64 is a 32-bit Windows

subsystem that allows you to run 32-bit applications on 64-bit Windows. Because

32-bit applications run in an emulation mode, we would suggest running 32-bit

applications on 32-bit hardware for optimal performance, and running 64-bit

applications on 64-bit OSs.

Failover Clustering (64-bit)

In Microsoft® SQL Server™ 2000 Enterprise Edition (64-bit), failover

clustering provides high availability support. For example, during an operating

system failure or a planned upgrade, you can configure one node of a failover

cluster to fail over to any other node in the failover cluster configuration. To

install, configure, and maintain a failover cluster, use SQL Server Setup. As

there are no previous 64-bit versions of SQL Server, you cannot upgrade an

existing failover cluster to a SQL Server 2000 (64-bit) failover cluster. Also

be aware that support for multiple instances of SQL Server differs in the

failover clustering scenario: you can create multiple virtual servers in a

cluster, but each virtual server can have only one instance of SQL Server

installed. Use failover clustering to:

  • Install SQL Server on multiple nodes in a failover cluster. You are

    limited only by the number of nodes supported by the operating system.

    Before installing failover clustering, you must install the Microsoft

    Cluster Service (MSCS) and the 64-bit versions of the Windows® Server 2003

    family (additional 64-bit versions of the Windows operating system for

    servers will be available for later releases of SQL Server 2000 [64-bit]).

    Because there is no 64-bit version of Windows NT® 4.0 or Windows 2000, you

    cannot install SQL Server 2000 (64-bit) with Windows NT 4.0 or Windows 2000.

  • Specify multiple IP addresses for each virtual server. With SQL Server

    2000 (64-bit), you can specify multiple IP addresses for each server, which

    allows you to use all available network IP subnets. This provides alternate

    ways to connect if one subnet fails, and increasing network scalability. For

    example, with a single network adaptor, a network failure can disrupt

    communications. But with multiple network cards in the server, each network

    can be on a different IP subnet. If one subnet fails, at least one

    connection can continue to function. If a router fails, MSCS continues to

    function, and all IP addresses still work. However, if the network card on

    the local computer fails, communication still may be disrupted.

  • Administer a failover cluster from any node in the clustered SQL Server

    configuration.

  • Allow one virtual server to fail over to any other node in the virtual

    server failover cluster configuration..

  • Add or remove nodes from the failover cluster configuration using the

    Setup program.

  • Reinstall or rebuild a virtual server on any node in the failover

    cluster without affecting the other nodes.

  • Perform full-text queries by using Microsoft Search service with

    failover clustering.

Installing a New Failover Cluster

To install this release of SQL Server 2000 (64-bit) using the graphical user

interface, follow these steps. For additional information about any steps in the

Installation Wizard, click Help at the bottom of the page within the Wizard.

Before you create a Microsoft SQL Server 2000 (64-bit) failover cluster, you

must configure Microsoft Cluster Service (MSCS) by using the Cluster

Administrator in the 64-bit Microsoft Windows operating system. Note the group

that contains the location of the cluster drive you want SQL Server to use by

using the Cluster

Administrator before you run SQL Server Setup. You will need this information to

create a new failover cluster.

1. Insert the SQL Server 2000 (64-bit) compact disc into your CD-ROM drive. If

you are installing from a network location, share the installation folder and

connect to the location from the computer where you want to install the program.

2. In the root folder of the compact disc or installation location on the

network, double-click Setup.exe.

3. Click Start a new installation. Select Virtual Server, which is the default

selection.

Note: This prompt appears only if there is a previously installed instance of

SQL Server on the computer or if you are installing a failover cluster.

4. On the Welcome page, click Next.

5. On the Registration Information page, enter the user name, a company name,

and the product key.

6. On the Software License Agreement page, read the license agreement and click

Yes to accept the license agreement. Clicking No ends Setup.

7. On the Virtual Server Name page, enter a virtual server name. This name

should be unique across the network.

8. On the Cluster Group Selection page, select the group that contains the drive

you want to use for SQL Server under Available Cluster Groups. This designates

the cluster group to locate the SQL Server virtual server resources. If you

select the group containing the cluster quorum resource, a warning will be

displayed recommending that you install to another group.

9. On the Failover Clustering page, enter one IP address for each network you

wish to configure for client access.

10. On the Instance Name page, choose a default instance or specify a named

instance. To install the default instance, click Default instance and then click

Next. If a default instance has already been installed, all additional SQL

Server instances on the machine must be named instances. To install a named

instance, click Named instance and type a name for the instance.

Note: When installing a named instance, you must use ASCII characters below 128.

This applies even if you have set the operating system's regional settings to a

non-US locale, and non-English language.

Limitations

  • No upgrades from SQL Server 6.5 and 7.0
  • No remote installation
  • No English query
  • No Jet engine
  • No 32-bit tools (EM, QA, DTS Designer, Wizards, Development Tools)
  • However, 64-bit SQL Server can be remotely managed from a 32-bit client
  • No mixed 64-bit/32-bit processes are allowed. 64-bit program cannot call

    32-bit MDAC DLLs from a 64-bit.

  • 16-bit program is not supported on 64-bit OS
  • No support for 32-bit kernel-mode code

For More Information

For the latest information on SQL Server 2000 (64-bit) check out the SQL

Server 2000 (64-bit) Web site. Learn more about the 64-bit version of the

Windows operating system on the Microsoft Windows Web site.

Rate

Share

Share

Rate