• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 714
  • Last Modified:

Backup job is skipping ACT databases!

Can someone help me here, all of my ACT databases are being skipped by Backup Exec 11d!

Thanks
jdff
0
jdff
Asked:
jdff
  • 3
  • 2
2 Solutions
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
I don't think BackupExec can backup open SQL databases.

You have 2 choices:
1. Purchase the SA Password Utility from Sage Corporate Services
2. Use the  ACT! backup program which produces a ZIP file and backup that with Backup Exec.
0
 
SStrozCommented:
jdff,

ACT! installs a proprietary instance of SQL when installed.  If you have the SQL module for BackupExec you need the SA Password.  It is free for 30 or more users or approx. $500 for less than 30 users in the U.S.  You can contact Sage corporate sales to arrange this.

Another option is to use the built-in ACT! scheduler which will create a .zip file which can in turn be backed up by BackupExec.  Be careful, because the scheduler does NOT delete old backups so you'll need to maintain that.

Yet another option is to use batch files to stop the ACT! instance before BackupExec starts and then start it again after BackupExec runs.  That would look like this:

Net Start MSSQL$ACT7

Net Stop MSSQL$ACT7

Those are your options, let us know if you need anything else

Steve
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Steve, actually it's not proprietary, just a named instance
0
 
SStrozCommented:
GL,

At the conferences and in conversations with other Sage technical staff it's referred to as proprietary because you don't get the SA Password.

Steve
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
I don't think their definition of "proprietary" is correct - In computing terms, proprietary components are components that are unique to a specific manufacturer, and do not conform to preset standards.

As the database is an MS SQL database, it is a standard... and the SA password can be made available.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now