Applies To
	Product(s):	PROJECTWISE DYNAMIC PLOT SERVICE
	Version(s):	N\A
	Environment:	N\A
	Area:	IPLOT
	Subarea:	N\A
	Original Author:	Beverly Dawn Gentry, Bentley Technical Support Group

Problem

If a database is installed on the same server as the dynamic plot administrator using the "automatic" method (Windows 2008)- Where is the database file located on the server? What are the expected disk space requirements for the database? Is there a method to delete entries in the database should it grow too large?
 

Solution

In the “automatic� mode, the PW Dynamic Plot Service Administrator uses Microsoft SQL Server 2008 Express. The database files are created in the \Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA folder. The database files consist of the BentleyDPS.mdf and BentleyDPS_log.ldf.

In one sample test, approximately 60 plots created database files with an approximate size of 2304 KB and 1024 KB respectively.

How big should the database be? It all depends on how many plots you are going to generate. The amount of information stored for each plot in the database is fairly small.

Regarding a delete method, there is currently none. If you really wanted to do so, you can use the Microsoft SQL Server Management Studio to delete entries. The problem with deleting entries is how would one know if the printed plot is going to be “used� for markup. If you have a procedure whereby a plot is aged and no longer viable then you could have a procedure in place to clean up the database entries.