Microsoft KB Archive/821505

= HOW TO: Delete a School in Class Server =

Article ID: 821505

Article Last Modified on 8/13/2003

-

APPLIES TO


 * Microsoft Class Server 3.0 Standard Edition

-





IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



IN THIS TASK

 * SUMMARY
 * Stop Internet Services
 * Delete the Server Folder Data for the School
 * Delete the Database for the School
 * Delete the Registry Entry for the School
 * Restart Internet Services
 * REFERENCES



SUMMARY
This step-by-step article describes how to delete a school in Class Server.

back to the top

Stop Internet Services
Stop all Internet services that are running on the server. To do so, follow these steps:
 * 1) Click Start, and then click Run.
 * 2) In the Open box, type cmd, and then click OK.
 * 3) At the command prompt, type iisreset /stop, and then press ENTER.
 * 4) Type exit, and then press ENTER to quit Command Prompt.

back to the top

Delete the Server Folder Data for the School
Delete the server folder data for the school. To do so, follow these steps:
 * 1) Start the Class Server Configuration tool.
 * 2) If you have multiple schools, click the school that you want to delete in the Select a School dialog box, and then click OK.
 * 3) Click the Server and Database tab.
 * 4) Under Server, make a note of the location of the server data folder that is displayed in the Server data folder box.
 * 5) Start Windows Explorer, and then locate the server data folder.
 * 6) Right-click the server data folder, and then click Delete.

Important Make sure that you delete only the server data folder for the school that you want to delete. Do not delete a parent root folder.

For example, if the path for the school that is displayed in the Server data folder box in step 4 is C:\ClassServerData\MySchool, make sure that you delete only the MySchool folder.
 * 1) Click Yes when you are prompted to confirm the deletion.

back to the top

Delete the Database for the School
Delete the database that is used for the school. To do so, do one of the following, depending on whether you are using Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (MSDE).

Microsoft SQL Server 2000
If you are using Microsoft SQL Server 2000, follow these steps:  On the Server and Database tab of the Class Server Configuration tool, under Database, make a note of the database server name that is displayed in the Database server and of the database name that is displayed in the Database name box. Click Start, and then click Run. In the Open box, type cmd, and then click OK. At the command prompt, type the following line, where  is the name of the server,   is the database that you want to delete, and   and   are the user name and password of a user with sufficient permissions to delete the database, and then press ENTER:

isql -S  -U   -P   -d master -q &quot;drop database DatabaseName&quot;

Important The switches for the isql command are case-sensitive. Additionally, the user whom you specify in the command line must have appropriate permission to delete the database.

For example, to delete a database named MyDatabase on a server named MyServer by using the User1 user account whose password is ********, type the following line, and then press ENTER:

isql -S MyServer -U User1 -P ******** -d master -q &quot;drop database MyDatabase&quot;

  You receive confirmation messages that are similar to the following in the Command Prompt window, where  is the name of the server,   is the database that you want to delete, and   and   are the user name and password of a user with sufficient permissions to delete the database, and then press ENTER:

osql -S  -U   -P   -d master -q &quot;drop database DatabaseName&quot;

Important The switches for the osql command are case-sensitive. Additionally, the user whom you specify in the command line must have appropriate permission to delete the database.

For example, to delete a database named MyDatabase on a server named MyServer by using the User1 user account whose password is ********, type the following line, and then press ENTER:

osql -S MyServer -U User1 -P ******** -d master -q &quot;drop database MyDatabase&quot;

  You receive confirmation messages similar to the following in the Command Prompt window, where
 * 1) Identify the GUID registry subkey that represents the school that you want to delete. To do so, click a GUID subkey, and then in the right pane, double-click  . Make a note of the school name that is displayed in the Value data box. Repeat this step until you locate the GUID subkey with the   value that matches the name of the school that you want to delete.
 * 2) Right-click the GUID subkey that you identified in step 4, and then click Delete.
 * 3) Click Yes when you are prompted to confirm the deletion.

back to the top

Restart Internet Services
Restart Internet services on the server. To do so, follow these steps:
 * 1) Click Start, and then click Run.
 * 2) In the Open box, type cmd, and then click OK.
 * 3) At the command prompt, type iisreset /start, and then press ENTER.
 * 4) Type exit, and then press ENTER to close the command prompt.

back to the top

<div class="references_section">