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.