win2008 R2 solution for installing SQL Server 2000 problems _win servers

Windows 2008 R2 64 system Installation SQL2000 32-bit database

Installation Success Key:

1, click on the installation, prompted compatibility issues, and then no then ... No response.

Workaround: Run the CD directly \microsoft SQL Server 20,004 All-in-one \enterprise\x86\setup\setupsql. Exe

Select \enterprise\x86\setup\setupsql.exe belongs to-compatibility mode (check compatibility Windows 2003 SP1, Admin), 4-in-1 version, find the installation version under Setupsql.exe, you can.

2, installation way out of Windows Program Compatibility Small assistant, directly ignore the past.

3, installation SP4 patch is also found: Sql2000\sql2ksp4\x86\setup\setupsql.exe belongs to-compatibility mode (check compatibility Windows 2003 SP1, Admin). The patch is installed after the normal steps, may jump out of error prompts, you can try to restart the computer, see

Whether the installation is complete. (The reboot should basically be successful after installation.) ）

4, Sync Center prompts, resolved as follows: "Start"-"Run"-"regedit" in "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows

\currentversion\syncmgr\handlers

Item to find one in the

SQL Server 2000

Related branch, delete it,

The Sync Center icon in the taskbar should disappear and the Sync Center will not start automatically after restarting.

Here are some of the normal installation steps:

1: Click Install, hint compatibility problem, then no then ... No response.

Workaround: Run the CD directly \microsoft SQL Server 20,004 All-in-one \enterprise\x86\setup\setupsql. Exe

2: Install to half hint General network error

Solution: Change the name of the computer to uppercase

3: Because the above error, so you have to uninstall, uninstall, the prompt can not find the installation log file uninstall process will terminate

The solution, this is copied on the Internet

Delete the SQL installation directory under Program files (please back up if important data is available here)
C:\Program Files\Microsoft SQL Server\80\Tools.
C:\Program Files\Microsoft SQL Server\MSSQL.

Relevant information in the registry is deleted:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSDTC.
3. Locate the PendingFileRenameOperations project in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager and delete it. This allows you to clear the installation pending items

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup
Delete Exceptioncomponents

The Sqlstp.log file in the Windows directory is to be deleted, which lists the details of what the installer is doing and includes any errors encountered during installation. By examining the file, you can learn more about where the installation failed and why it failed.

4: After installation, and prompted not to start the Server service

And there's only one launcher in the sqlserver2000, that's the beginning, the stop, the rest of the stuff that we usually see.

5: So just uninstall again, this uninstall is still very fast, I delete all the SQL related folders, to install again

Run the CD directly \microsoft SQL Server 20,004 All-in-one \enterprise\x86\setup\setupsql. Exe

Be sure to check that this is the default, otherwise, it means that you are here, and sql2000 did not uninstall the end, you repeat the above tragedy? ·

6: If hung up ...

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager
Delete PendingFileRenameOperations

7: Install complete, play SP4 patch, and then remember to go to the management inside, find services, open SQL Server Agent this service

8: Copy the original database to the database folder (System of what Northwind these default from the database, do not copy over)

Then attach, add user name Please read this article (http://www.jb51.net/article/40744.htm)


In addition, in order to ensure the security of the database, we do a database maintenance plan every 2 days, backup once, and delete 2 weeks ago Backup

Re-organize data and index pages, once every 2 days, at 1 o'clock in the morning

And then once every 2 days, back up the database, which happens at 2 o'clock in the morning

Backup the database, back up to the specified folder, and delete the backup database 2 weeks ago