Community
Showing results for 
Search instead for 
Do you mean 
Reply

ADF and ALF File Locations

Accepted Solution Solved
Copper Contributor
Posts: 51
Country: United States
Accepted Solution

ADF and ALF File Locations

I recently read, possibly in the SDK but also possibly in one of the white papers, that the ADF and ALF (data and log) files needed to be in the same location.  There are two really good reasons* for putting an SQL Server log file on a different device from the data file and I would like to do this with our installation.

 

Is there a way to move the ACT! SQL Server log file to a different location?

 

Thanks,

 

Larry

 

* Reasons for splitting the data and log files

1. A single hardware failure doesn't take out both files.

2. You aren't waiting on the same device to write both files during database actions.


Accepted Solutions
Solution
Accepted by gmartin (Platinum Super Contributor)
‎09-25-2015 03:20 AM
Moderator
Posts: 4,395
Country: USA

Re: ADF and ALF File Locations

The ADF and ALF are required to be in the same location.  You should look into setting up a RAID environment.  This will increase performance and fault tolerance.

 

http://en.wikipedia.org/wiki/RAID

View solution in original post


All Replies
Solution
Accepted by gmartin (Platinum Super Contributor)
‎09-25-2015 03:20 AM
Moderator
Posts: 4,395
Country: USA

Re: ADF and ALF File Locations

The ADF and ALF are required to be in the same location.  You should look into setting up a RAID environment.  This will increase performance and fault tolerance.

 

http://en.wikipedia.org/wiki/RAID

Copper Contributor
Posts: 51
Country: United States

Re: ADF and ALF File Locations

Thanks, David,

 

It is already a RAID environment so we'll have that strength.  I am just very conservative with respect to scalability and backup and I just prefer to have the log file on a different device for both of those reasons.  If we can't, we can't and we'll deal with it.

 

Thanks again for the answer.

 

Larry