Share via

Deleting All Data from Data Warehouse

  • Article

When the "delete all" option is used to delete all data from the Data Warehouse, most tables in the Data Warehouse are deleted. The only tables not deleted from the Data Warehouse are tables that have no associated logical class. The following is a list of tables that remain in the Data Warehouse after deleting all data from the Data Warehouse:

  • Site
  • ServerGroup
  • VirtualServer
  • ServerBinding
  • SiteURL
  • EventType
  • SVQStringName
  • MVQStringName
  • LinkSVQStringName
  • LinkMVQStringName
  • ImportOptions
  • Crawler

For instructions about running the Data Deletion DTS task in Commerce Server Manager to delete all data, see To delete all data in the Data Warehouse.

Copyright © 2005 Microsoft Corporation.
All rights reserved.