01-28-2014 09:31 PM
I'm using ACT 2008 Pro on a server with about 8 clients. I've been backing up using one of the terminals but heard somewhere that in order to be able to restore a backup using this version of ACT that I need to shut down SQL and do the backups from the server install.
Luckily I've not yet needed to do a restore to find out if this is true, but I would sure appreciate it if anyone had some input on this and post the correct backup procedure.
Thanks in advance
01-29-2014 09:04 AM
This may help with your back up needs. Its free. http://fillstaff.com/backupfolderspro.html - Cheers - FSB
01-29-2014 11:19 AM
@Fillstaff,
The link takes me to a nice Act Backup organizer. But it doesnt seem to address the concern.
What I am wondering about is does SQL need to be shut down whe backing up to get a file that is fully restorable when using on a different install?
If my server crashes or gets contaminated and I need to do a complete reinstall, I seem to recall something about the SQL backup being machine specific. If so, would that make restoring the backup an issue under this example?
I could be wrong but any comments would be appreciated.
01-29-2014 12:25 PM - edited 01-29-2014 12:27 PM
I have never heard of having to stop the sql server.
Use ACT! / File / Backup / Backup Database
My Backup folders Pro allows you to better manage your backups.
you dont want any syncing going on at time of backups - so perhaps stop sync services.
also you dont want any online auto backups running at time of backups.