Jump to content

One Database is 500 Megs!!????


This topic is 5766 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Ok, this is a bit strange.

We have a filemaker pro server with several databases. Recently several databases have been crashing. I found out that one of the databases is 500 Megs in size!

This is a database that we rarely use, we use it only for tracking our quotes.

We can't figure out why it is so huge

Is there any way to check out the size, or to look into everything. Our average size is around 30 to 100 megs.

There is only 1 container field. There are 900 records, and half of them have a pdf in the container field. the other records have nothing in the container.

Largest size of these pdf's is 18kB - so there is no reason why it should be so huge.

thanks!

Edited by Guest
Link to comment
Share on other sites

Well, first backups are no problem, our databases are stored on a folder on our NetApp data server. It kicks of a snapshot every hour on that folder in th event any problem is detected we can jump back x number of hours in time!

The thing here is that this has been going on for months and i never found out about it.

Also we have another database with our service contracts. Each record has a pdf of the contract attached to it. This database has 4 or 5 tables, and much more relationships and pdf attachments that are 2 or 3 times the size of the average attachment of the database in question.

And yet the database with service contracts is only 99 megs in size.

Xoomaster, where is this optimize option at?

Link to comment
Share on other sites

Well, first backups are no problem, our databases are stored on a folder on our NetApp data server. It kicks of a snapshot every hour on that folder in th event any problem is detected we can jump back x number of hours in time!

Copies of open files made in this manner are not safe to work with. Use Server's built-in backup scheduling to make a local backup, then take snapshots of those with your backup software.

Link to comment
Share on other sites

This topic is 5766 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.