Find the limit!

[cryrep]

I got a message say Your over 1.81gb and your limit to 2gb for you database,

Where i could see the exacte size of this database. Is there something i could do to wait 2 or 3 month before i spend 3000$ on a new SQL server?

We runnig GP from 17 month, I need the small history that i have but maybe i can delete something?

 

[jymm]

which version of SQL & GP are you running?

I would check the options for the database - is the transaction log and the recovery model sep appropriatly for your shop?

If you are really looking for exact size you can go into Enterprise manager (if you do not have it, your DBA will), in SQL 2k you can right click on the database and choose properties - there you can see the sizes of the data file & the transaction file, but these are allocated sizes and not how much the data is really taking (but close enough).

In GP 8 (sorry - do not remember how to get there in older versions, but it seems it was similar) you have to have everyone out of the company then you can go to File->Maintenance->clear data and choose what you want to get rid of. When I do this I always get a backup of the company first so that I can always put things back.

Personally I have a database that is just out there to monitor growth of each database and then I run a weekly snaphot job which allows me to see when things are growing too big before things like this happen. If you need that - let me know. I also run a weekly shrink on the databases for the server just to free up the space a bit or keep the numbers more believable - let me know if you need this too.

 

[jpotucek]

I suspect you are using MSDE for you back-end which has a 2GB limit on DB size