Microsoft Knowledge Base Email Alertz

(821505) - 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: Click Start, and then click Run.In the Open...

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]

Search KbAlertz

Advanced Search

Webmasters
Put kbAlertz on your website.
[ Click Here for more! ]





ASP.NET 3.5 Web Hosting with Windows 2008 and SQL 2008: Click Here!
Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
KBAlertz referrals get
** SIX MONTHS FREE **


Community Site



We Send hundreds of thousands of emails using ASP.NET Email


ASP.NET 3.5 Web Hosting with Windows 2008 and SQL 2008: Click Here!
Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
KBAlertz referrals get
** SIX MONTHS FREE **




Mentioned In








Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks




Article ID: 821505 - Last Review: August 13, 2003 - Revision: 1.1

HOW TO: Delete a School in Class Server

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  (http://kbalertz.com/Feedback.aspx?kbNumber=256986/EN-US/ ) Description of the Microsoft Windows Registry

On This Page

SUMMARY

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

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.

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.
  7. Click Yes when you are prompted to confirm the deletion.

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:
  1. 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.
  2. Click Start, and then click Run.
  3. In the Open box, type cmd, and then click OK.
  4. At the command prompt, type the following line, where Server is the name of the server, Database is the database that you want to delete, and UserName and Password are the user name and password of a user with sufficient permissions to delete the database, and then press ENTER:
    isql -S Server -U UserName -P Password -d master -q "drop database DatabaseName"
    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 "drop database MyDatabase"
  5. You receive confirmation messages that are similar to the following in the Command Prompt window, where <Database> is the name of the database that you deleted:
    Deleting database file '<Drive>:\Program Files\Microsoft SQL
    Server\MSSQL\data\<Database>_Log.LDF'.
    
    Deleting database file '<Drive>:\Program Files\Microsoft SQL
    Server\MSSQL\data\<Database> _Data.MDF'.
    Type exit, and then press ENTER to quit Command Prompt.

Microsoft SQL Server2000 Desktop Engine

If you are using Microsoft SQL Server2000 Desktop Engine (MSDE), follow these steps:
  1. 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.
  2. Click Start, and then click Run.
  3. In the Open box, type cmd, and then click OK.
  4. At the command prompt, type the following line, where Server is the name of the server, Database is the database that you want to delete, and UserName and Password are the user name and password of a user with sufficient permissions to delete the database, and then press ENTER:
    osql -S Server -U UserName -P Password -d master -q "drop database DatabaseName"
    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 "drop database MyDatabase"
  5. You receive confirmation messages similar to the following in the Command Prompt window, where <Database> is the name of the database that you deleted:
    Deleting database file '<Drive>:\Program Files\Microsoft SQL
    Server\MSSQL\data\<Database>_Log.LDF'.
    
    Deleting database file '<Drive>:\Program Files\Microsoft SQL
    Server\MSSQL\data\<Database> _Data.MDF'.
    Type exit, and then press ENTER to quit Command Prompt.

Delete the Registry Entry for the School

Delete the registry entry for the school. To do so, follow these steps. WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
  1. Click Start, and then click Run.
  2. In the Open box, type regedit, and then click OK.
  3. Locate, and then double-click the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Class Server\Server\Schools
  4. 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 SchoolName. 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 SchoolName value that matches the name of the school that you want to delete.
  5. Right-click the GUID subkey that you identified in step 4, and then click Delete.
  6. Click Yes when you are prompted to confirm the deletion.

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.

REFERENCES

For more information about how to install, configure, and administer Class Server 3.0, see the Microsoft Class Server Administrator's Guide. The Class Server Administrator's Guide (AdminGuide.htm and AdminGuide.pdf) is located in the root folder of the Microsoft Class Server3.0 CD-ROM.


APPLIES TO
  • Microsoft Class Server 3.0 Standard Edition
Keywords: 
kbinfo KB821505
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate