Uninstall an existing instance of SQL Server (Setup)

Applies to: SQL Server - Windows only

Bạn đang xem: how to uninstall sql server 2008

This article describes how vĩ đại uninstall a stand-alone instance of SQL Server. By following the steps in this article, you also prepare the system sánh that you can reinstall SQL Server.

To uninstall a Cumulative Update, see Uninstall a Cumulative Update from SQL Server.

Considerations

To uninstall SQL Server, you must be a local administrator with permissions vĩ đại log on as a service.
If your computer has the minimum required amount of physical memory, increase the size of the page tệp tin vĩ đại two times the amount of physical memory. Insufficient virtual memory can result in an incomplete removal of SQL Server.
On a system with multiple instances of SQL Server, the SQL Server browser service is uninstalled only once the last instance of SQL Server is removed. The SQL Server Browser service can be removed manually from Programs and Features in the Control Panel.
Uninstalling SQL Server deletes tempdb data files that were added during the install process. Files with tempdb_mssql_*.ndf name pattern are deleted if they exist in the system database directory.

Prepare

Back up your data. Either create full backups of all databases, including system databases, or manually copy the .mdf and .ldf files vĩ đại a separate location. The master database contains all system level information for the server, such as logins, and schemas. The msdb database contains job information such as SQL Server agent jobs, backup history, and maintenance plans. For more information about system databases, see System databases.

The files that you must save include the following database files ¹:
- master.mdf
- mastlog.ldf
- msdbdata.mdf
- msdblog.ldf
- model.mdf
- modellog.ldf
- mssqlsystemresource.mdf
- mssqlsystemresource.ldf
- ReportServer[$InstanceName] data and log files ²
- ReportServer[$InstanceName]TempDB data and log files ²
¹ You can't back up the tempdb system database.

² The ReportServer databases are included with SQL Server Reporting Services.
Stop all SQL Server services. We recommend that you stop all SQL Server services before you uninstall SQL Server components. Active connections can prevent successful uninstallation.
Use an trương mục that has the appropriate permissions. Sign in vĩ đại the server by using the SQL Server service trương mục or by using an trương mục that has equivalent permissions. For example, you can log on vĩ đại the server by using an trương mục that is a thành viên of the local Administrators group.

Uninstall

Windows 10 / năm 2016 +
Windows 2008 - 2012 R2

To uninstall SQL Server from Windows 10, Windows Server năm 2016, Windows Server 2019, and greater, follow these steps:

To begin the removal process, navigate vĩ đại Settings from the Start thực đơn and then choose Apps.
Search for sql in the tìm kiếm box.
Xem thêm: cách nấu rượu nếp than
Select Microsoft SQL Server (Version) (Bit). For example, Microsoft SQL Server 2017 (64-bit).
Select Uninstall.
Select Remove on the SQL Server dialog pop-up vĩ đại launch the Microsoft SQL Server installation wizard.
On the Select Instance page, use the drop-down box vĩ đại specify an instance of SQL Server vĩ đại remove, or specify the option vĩ đại remove only the SQL Server shared features and management tools. To continue, select Next.
On the Select Features page, specify the features vĩ đại remove from the specified instance of SQL Server.
On the Ready vĩ đại Remove page, review the list of components and features that will be uninstalled. Select Remove vĩ đại begin uninstalling
Refresh the Apps and Features window vĩ đại verify the SQL Server instance has been removed successfully, and determine which, if any, SQL Server components still exist. Remove these components from this window as well, if you sánh choose.