Accpac backup solution? 1

[BeW23]

What is the best way to backup Accpac 5.5A? Im using Accpac 5.5A and MSQL 2005. Any help would be greatly appreciated.

Thank you.

 

[Jay Converse]

Nothing fancy, use regular SQL backups, and whatever backup solution you prefer, like Symantec Backup Exce.

 

[BeW23]

Thank you for replying.. Im thinking about using Acronis, what software do you recommend?

 

[Jay Converse]

I never heard of Acronis before, I use Symantec Backup Exec.

 

[ramam1]

A SQL backup is preferred over DBUMP? My intent is to script nightly backups to push offsite for recovery.

 

[Jay Converse]

Using Dbdump as a backup method is an Accpac urban legend that won't die. Dbdump takes 10 times as long as a SQL backup, you do the math.

 

[ramam1]

Okey dokey. I've been using DB* to move snapshots between dev an prod and figured it was a reasonable choice -> SQL dumps are easy enough.
thanks

 

[Jay Converse]

Indeed, Dbdump is useful for moving data between servers, databases, and installations, but it's not the preferred method for production to production copies.