Community
Showing results for 
Search instead for 
Do you mean 
Reply

Backup database while user is using

Tuned Listener
Posts: 55
Country: Malaysia

Backup database while user is using

If the data is located at server, is it possible to do a backup of database while other users also accessing the same database?  Is it a MUST that all other users log out from ACT and leave only the Administrator alone to do the backup database?

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Backup database while user is using

If you use the backup within ACT! (File | Backup) or through the ACT! scheduler, it will still be fine with users logged in
Copper Contributor
Posts: 14
Country: Switzerland

Re: Backup database while user is using

One more of my questions answered also!!

Cheers Mike 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Backup database while user is using

But, if using a different backup utility (ie not ACT!) that doesn't have specific SQL knowledge, or without the SA pass, you need to stop the ACT! services first... which means the users get booted