Remove Unused Items

Remove Unused Items

The command removes all unused items from AdServer Database Data (AdServer.mdb) to backed up (AdSvrDel.mdb) database. If the database not exists, system will create new database of the same name in the directory, where AdServer.mdb database occurs.

Database application selects unused items and then asks the user, if data can be deleted. If user answers "Yes", the data will removed from AdServer.mdb database to AdSvrDel.mdb database. If there are not corresponding tables in target database, system will create this one with "del_" prefix to differentiate, that data in the tables were deleted from original database system.

System search for unused items in that order:

1.	Expired campaigns and their corresponding data in stats and stat_details tables.
2.	Unused data in banner_weights table.
3.	Unused orders and their corresponding data in stats and stat_details tables.
4.	Unused banners and their corresponding data in stats and stat_details tables.
5.	Unused data in advertisers table.
6.	Unused data in stats table.

Applies To

AdServer Database Application