Review

3 4

Here are some questions to help you determine whether you have learned enough to move on to the next chapter. If you have difficulty answering these questions, review the material in this chapter before beginning the next chapter. The answers for these questions are located in the Appendix, "Questions and Answers."

1. You are planning to upgrade your SQL Server 7.0 installation running on Windows NT 4.0 Server to SQL Server 2000. You want to test SQL Server 2000 on the same computer on which you currently have SQL Server 7.0 installed, and you need to keep the SQL Server 7.0 installation available for users. What issues do you need to consider?
2. You have recently performed a version upgrade of SQL Server 7.0 to SQL Server 2000. Although overall performance has improved, full-text searches are not working. Why might this be?
3. You have decided that you cannot afford the downtime associated with a version upgrade of your SQL Server 7.0 installation and have decided to perform an online database upgrade of your production databases. What settings and objects will you have to re-create manually?
4. You have been testing SQL Server 2000 on the same computer on which you have been running your SQL Server 6.5 installation. You decide to upgrade your SQL Server 6.5 installation. However, you cannot locate the SQL Server Upgrade Wizard. It is not located on the Start menu and you cannot find it on your hard drive. Why?

Answers