This topic applies only to SQL Server 2000 (64-bit).

You can use the setup command line with the REINSTALL and REINSTALLMODE properties to repair an instance of Microsoft® SQL Server™ 2000 (64-bit). The REINSTALL property triggers the reinstallation of program files and the REINSTALLMODE property specifies the type of reinstall. Its two different settings, amus and omus, both repair and verify an instance of SQL Server. Additionally, the amus setting repairs a corrupted master database and the omus setting rebuilds the registry. These properties can be specified on the command line or in an .ini file.

Rebuilding the Registry

Use the setup command line with the REINSTALL=ALL and REINSTALLMODE=omus property settings to rebuild the registry for a corrupted installation of SQL Server 2000 (64-bit). Running Setup.exe with these property settings rebuilds, verifies, and repairs the installation of an instance in addition to rebuilding the registry.

Important  To rebuild the registry, you must use the same package file and choices that you entered during the initial installation. If you do not know this information, first uninstall and then reinstall SQL Server rather than using the command line.

Rebuilding the Master Database

Use the setup command line with the REINSTALL=ALL and REINSTALLMODE=amus property settings to rebuild the master database for a corrupted installation of SQL Server 2000 (64-bit). Running Setup.exe with these property settings rebuilds, verifies, and repairs the installation of an instance in addition to rebuilding the system databases. When you use REINSTALLMODE=amus, you can modify the security settings (SECURITYMODE and SAPWD) and the collation setting (COLLATION).

Security Note  When possible, use Windows Authentication. Do not leave the sa password blank; always use strong passwords.

See Also