Some hard work to reinstall SQL Server 2 k

Source: Internet
Author: User
Previously, SQL Server 2005 was installed on disk D, and Ghost had a copy of the operating system Win2k3. After some experience of SQL 2005, it is Based on. Net, and the function and size are mostly compared with the 2 k version; of course, these two reasons also restrict its speed as low as 2 k. The company uses 2 k for projects. Finally, I uninstalled SQL 2005 and reinstalled it with 2 k. Everything went smoothly.

However, the version 2005 database cannot be downgraded to a 2 k database, which is really a headache. When I got angry with the Internet and didn't find a solution, I finally took the most stupid approach:
1. Export SQL scripts from 2005;
2. export data to excel;
3. Modify the SQL statement (the SQL script exported in 2005 may not run in 2 k );
4. Run the SQL script in 2 k;
5. import data from excel.

Pain, and finally solved it.

Recently, Windows was running very slowly, so ghost restored Windows, uninstalled the original SQL 2005 record in "Add/delete programs", and then installed SQL 2000. An error occurred. If you want to uninstall and reinstall the file, an error is reported, indicating that the file cannot be detached.

As a result, SQL 2000 cannot be installed, but cannot be uninstalled. It is a dilemma. This is the most painful thing for programmers.

In desperation, the most absolute method is used:
1. Copy the SQL database;
2. Delete the SQL installation folders, including drive C and drive D;
3. Use the Super Rabbit to clear and compress the registry;
4. The service that modifies the Registry deletes the remaining services in 2005;
5. Install SQL 2 k again.

OK.

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.