Cimplicity Database Maintenance

G

Thread Starter

Gordone

Hi,

I have a plant running with A server and 3 clients.

Cimplicty 6.10 SP6
Microsoft Management Console 3.0, Version 5.1 SP3

Now after years for running has CIMPLICITY.mdf filled up the C: partition. My plan is to move the database to D: partition, decrease size of the database (almost 9GB today...) and activate maximum size of partition.

1. Moving database
http://www.thewindowsclub.com/move-microsoft-sql-server-database
Use these guide?

2. Decrease size of database
How can I do these, without make any thing corrupt or make problem for Cimplicity?

3.
Activate maximum size of partition, I plan to activate "Restrict file growth (MB)" to 10 GB, that will work?

What happens when the database reach 10GB, will Cimplicity start to overwrite oldest data or will everything just stop up?

Today Automatically grow file "By percent" is activated 10%, maybe it would be better to switch to "In Megabytes" and add 100MB example?
Because 10% higher and higher when the database grow..?

Thank you for using time on me on these matter.
 
Top