When you delete a Visitor Data Mart profile, it is removed from
the Administration interface, but its databases persist, occupying disk space
on Event Database servers. A database administrator can use the instructions below
to manually delete profile databases after a profile has been deleted in
On the computer where your Webtrends system database is located,
run the following stored procedure against the wtMaster
database. The procedure returns a list of event databases in the
EventDatabaseName column associated with
deleted Visitor Data Mart profiles and the servers and instances on which these
On the Event Database server, find the databases in SQL Server by
looking at the ServerName and InstanceName columns.
Delete the databases using SQL Management Studio.
Note: If you run the stored procedure again, after manually
deleting databases, the list will not reflect the deletions. All profile
databases that have ever been deleted from Administration appear in the
list, regardless of whether they have already been deleted.