Remove database from sql

[Anonymous]

With vault we are using different databases. A different one for each client. Some of these vaults get obsolete after a while and will be deleted from the server.

So far everything is well, but I presently noticed that vault or the sql server remembers these deleted vaults while backing up. There are 5 vaults attached tot the server, but the backup script runs how lot more.

For so far this hasn't caused any real problems, but I while work continues, these redundant database could really slow things down. Is there a way to really delete these vaults?

TIA
Matthjis

[Anonymous]

Have you deleted the vaults via ADMS console? You should see a list of
vaults and be able to delete via the context menu.

Deleting the databases from SQL directly will not remove knowledge of them
from the system. This may be what you are seeing.

Paul Gunn

wrote in message news:5892328@discussion.autodesk.com...
With vault we are using different databases. A different one for each
client. Some of these vaults get obsolete after a while and will be deleted
from the server.

So far everything is well, but I presently noticed that vault or the sql
server remembers these deleted vaults while backing up. There are 5 vaults
attached tot the server, but the backup script runs how lot more.

For so far this hasn't caused any real problems, but I while work continues,
these redundant database could really slow things down. Is there a way to
really delete these vaults?

TIA
Matthjis

[Anonymous]

Hi Paul,

I've deleted the vault on the vault server using ADMS console. Honestly I wouldn't know any other way... Deleting these vault via the context menu wasn't a problem, in there the don't reappear.
This strange problem came to my attention when I was checking the backup logs and saw far more databases then the few that were mentioned in de ADMS console.

Matthijs

[Anonymous]

Could you post the logs? Offhand, I'm not sure what could be causing what
you are seeing.

Thanks,

Paul

wrote in message news:5893074@discussion.autodesk.com...
Hi Paul,

I've deleted the vault on the vault server using ADMS console. Honestly I
wouldn't know any other way... Deleting these vault via the context menu
wasn't a problem, in there the don't reappear.
This strange problem came to my attention when I was checking the backup
logs and saw far more databases then the few that were mentioned in de ADMS
console.

Matthijs

[Anonymous]

Paul,
Here is the log file.
As you can see, the number of databases has increased after I had created en thereafter deleted an test vault. In the screenshot of the ADMS Console you can see that there are 'only' 17 vaults active, not even close to the 52 that are logged while backing up.

What also seems odd, is that the ADMS Console reports as "Not Backed Up", while I am backing up almost every day.

Matthijs

[Anonymous]

Hi Matthijs,

the number reported in the log file is the same as the progress dialog is
showing, and granted it is misleading if it shows a number of 52 which has
nothing to do with your 17 Vaults.
18-3-2008 19:14:53 Backing Up Databases... 29/52
Paul can probably expand a little more on the meaning of this number.

Meanwhile you can check the databases subfolder of your resulting backup. If
it contains 18 files (17 Vaults + KnowledgeVaultMaster) it does the right
thing.

Thomas

wrote in message news:5894955@discussion.autodesk.com...
Paul,
Here is the log file.
As you can see, the number of databases has increased after I had created en
thereafter deleted an test vault. In the screenshot of the ADMS Console you
can see that there are 'only' 17 vaults active, not even close to the 52
that are logged while backing up.

What also seems odd, is that the ADMS Console reports as "Not Backed Up",
while I am backing up almost every day.

Matthijs

[Anonymous]

Hi Thomas,

Thanks for your reply.
You are right, if I check the backup database subfolder, it only contains the vaults that are shown in the ADMS Console. And for now there isn't a real problem.
But considering our workflow, it is most likely that we have to create, and afterwards delete, a lot of vaults. If we continue like this and we aren't able to tackle this, I fear that backing up could take a lot of time and that the log file isn't readable any more.

Matthijs

[Anonymous]

Hi Matthijs,

Thomas is correct that the numbers reflect the progress 'ticks'. For each
vault, there are a few discrete operations per backup - e.g. backup the
database, backup the filestore. So the total for the data in the screenshot
might be 1 (knowledge master) + 7 (library databases) + 17 (vault databases)
+ 17 (vault filestores) = 42 (which is number of steps in the first backup
logged)

ADMS console takes the approach of basically logging out information that
the user sees - in this case it is probably not that helpful. However, the
number will always be fixed based on the total number of vaults and
libraries on the system. Deleted vaults should never affect this count.nor
should they affect the backup time.

Paul

wrote in message news:5895115@discussion.autodesk.com...
Hi Thomas,

Thanks for your reply.
You are right, if I check the backup database subfolder, it only contains
the vaults that are shown in the ADMS Console. And for now there isn't a
real problem.
But considering our workflow, it is most likely that we have to create, and
afterwards delete, a lot of vaults. If we continue like this and we aren't
able to tackle this, I fear that backing up could take a lot of time and
that the log file isn't readable any more.

Matthijs

[Anonymous]

Hi Paul,

However I slightly disagree with your method of counting (libraries shouldn't be taken along while backing up, the log file speaks of 46 instead of 42 and screenshot has been made after the second backup is logged 52 steps), but I hope you are right. I will monitor my log file the following days and see what it does.

Matthijs