Community
Showing results for 
Search instead for 
Do you mean 
Reply

Database Files

Accepted Solution Solved
New Member
Posts: 7
Country: United Kingdom
Accepted Solution

Database Files

How do i find out the Total Size of a Database?

 

 


Accepted Solutions
Solution
Accepted by ghollister (Platinum Elite Contributor)
‎09-25-2015 03:20 AM
Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Database Files

Hello ITGeek,

Welcome to the Act! Online Community!

 

There are 4 'pieces' to an Act! database:

3 files - 'databasename.ADF', 'databasename.ALF', and 'databasename.PAD'.

1 Folder - 'databasename-database files'

 

For a total size you will add up the sizes of all 4 of these.

 

If you are running SQL Server 2005 Express and concerned that you are getting near the 4gb limit, only the ADF file is of concern.  The 'database files' folder is not included in this calculation.

Greg Martin
Sage

View solution in original post


All Replies
Solution
Accepted by ghollister (Platinum Elite Contributor)
‎09-25-2015 03:20 AM
Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Database Files

Hello ITGeek,

Welcome to the Act! Online Community!

 

There are 4 'pieces' to an Act! database:

3 files - 'databasename.ADF', 'databasename.ALF', and 'databasename.PAD'.

1 Folder - 'databasename-database files'

 

For a total size you will add up the sizes of all 4 of these.

 

If you are running SQL Server 2005 Express and concerned that you are getting near the 4gb limit, only the ADF file is of concern.  The 'database files' folder is not included in this calculation.

Greg Martin
Sage
New Member
Posts: 7
Country: United Kingdom

Re: Database Files

Thanks