Close window

printed by () 05/09/2024 21:29:30
FAQ#: 1000262 / Deleting of several databases with the recycle bin function
FAQ-Info:
Category: English::CADISON::Installation & Maintenance
Language: en
Votes: 0
Result: 0.00 %
Last update: 05/09/2018 10:44:25

Keywords: Delete database several recycle bin

Symptom: (public)

Problem: (public)
Over the PDM it´s only possible to delete databases one by one and just from the user who has created the database.

Solution: (public)
Therefore is the function "Move database to recycle bin" available. With this function you move a database to a specific database group. As second step the databases in this database group can be deleted with a ITFTOOL command.
In this case CADISON ignore who has created the databases originally and delete them all.

This way you can configurate this function:

1. Open PDM
2. Create a new database group (e.g. "RecycleBin") and close PDM.
3. Open the file CADISON.ini and add following row in the area [PHI-CADISON]:

RecycleBinFolder=(Name of database group e.g. "RecycleBin")

4. Save the CADISON.ini file
5. Open PDM again
6. Click with right mouse button on a database which should be deleted later an select "Move database to recycle bin". Now the database has been moved to "RecycleBin".
7. Repeat this with all databases, which you want to delete.
8. To delete all databases in "RecycleBin" database group at once, you can use the command "DELDBSINRB" on the server. Open DOS command window type following:

itftools -DELDBSINRB

Important:
Please run the command directly on the database server.
Be sure that nobody is working in CADISON during this command.
A good way is to run this command with the task scheduler after the backup service.

URL: http://cadison.org/cgi-bin/bin/cgi-bin/public.pl?Action=PublicFAQPrint;ItemID=262