Community
Showing results for 
Search instead for 
Do you mean 
Reply

Premium for Web 2009 Backups on the web server or the SQL Server?

Accepted Solution Solved
Loyal Listener
Posts: 32
Country: United States
Accepted Solution

Premium for Web 2009 Backups on the web server or the SQL Server?

I'm setting up my ACT Scheduler backups but I'm not sure which server I should be scheduling them. I'm running the database on a Win 2003 Server with SQL Server 2005. I'm running the web server on a Win Server 2003. Should I be running the backups on the DB server or the web server?

 

I've actually run the back up on both servers with different results. The web server yielded files upwards of 6GB where the SQL server is somewhere around 500MB. Both are set to backup attachments. Thoughts?

Thanks everyone.


Accepted Solutions
Solution
Accepted by topic author IT_Services
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Premium for Web 2009 Backups on the web server or the SQL Server?

Normally, you do this on the database server... but don't write them to the Backups folder in the database supplemental files folder.

 

Maybe this will help:

http://blog.glcomputing.com.au/2009/09/automating-backups-for-act-by-sage.html

View solution in original post


All Replies
Silver Elite Contributor
Posts: 3,344
Country: United_Kingdom

Re: Premium for Web 2009 Backups on the web server or the SQL Server?

Check the backup file location on your web server. Anything withing the ACT Database folder gets backed up so it's just possible you might be doing a backup of your backups.

 

Jeff

Jeff Granger
UK ACT! Specialist and Trainer

ACT Training Throughout The UK
www. bigbluemarketing.co.uk
Solution
Accepted by topic author IT_Services
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Premium for Web 2009 Backups on the web server or the SQL Server?

Normally, you do this on the database server... but don't write them to the Backups folder in the database supplemental files folder.

 

Maybe this will help:

http://blog.glcomputing.com.au/2009/09/automating-backups-for-act-by-sage.html