|
Joined: Aug 2005
Posts: 908
Member
|
Member
Joined: Aug 2005
Posts: 908 |
How will open CCS applications affect automated backup of CCS server databases?
We want to institute automatic backup of the CCS server database files. A number of our users leave CCS applications open 24/7. I am one of those people. I use Autoreporter within Reporter to generate reports nightly after our Call Centers close. Reporter is a historical program and not constantly accessing information. However, Reporter Realtime, Realviewer and Callviewer are in constant communication with the databases. These are all real time monitoring applications. Is it necessary for all users to close these applications in order to conduct a backup?
I use a scheduled task to XCopy the Avdap folder on the voicemail server. We've never had an issue. Of course there is no one using the phones at midnight on Friday.
|
|
|
Visit Atcom to get started with your new business VoIP phone system ASAP
Turn up is quick, painless, and can often be done same day.
Let us show you how to do VoIP right, resulting in crystal clear call quality and easy-to-use features that make everyone happy!
Proudly serving Canada from coast to coast.
|
|
|
Joined: Aug 2005
Posts: 6,692
Member
|
Member
Joined: Aug 2005
Posts: 6,692 |
There are some options, but I can tell you that when it comes to back ups, it's best not to cut corners. That's like paying a slightly discounted rate on insurance premiums for years and years to an offshore insurance company who decides not to pay when you have a claim.
We use a name brand back up software and pay the extra add on for the open file option. I think it's well worth it. PM me if you want the name and a dealer referral.
|
|
|
|
Joined: Aug 2005
Posts: 908
Member
|
Member
Joined: Aug 2005
Posts: 908 |
I couldn't agree with you more. We use Veritas 10. The issue is not with the backup. It's how to assure no corruption of the files during the transfer. Microsoft Access really doesn't like anyone fooling with its files. Especially if a file is open. We will ask all CCS users to close their applications each day. But you know the human factor in the equation is always the wild card. There are software packages that will either suspend or kill connections, but they don't always work. Our standard backup scenario is to take a snapshot of the files and copy them to a folder designated for backups. Veritas then backups the files from that folder. This keeps the backup function of Veritas, which can linger, from affecting the function of the system using the files. Our concern is what happens to the open files when we take the snapshot.
|
|
|
|
Joined: Aug 2005
Posts: 6,692
Member
|
Member
Joined: Aug 2005
Posts: 6,692 |
I try not to post brand names but that is what we're using. In fact I just got a memo that it's time to renew our agreement. The only difference is that we also run the "Open File Option" which will back up the open files as well.
|
|
|
|
Joined: Aug 2005
Posts: 908
Member
|
Member
Joined: Aug 2005
Posts: 908 |
Yeah, we have that as well. We're still gun shy when it comes to Microsoft Access.
|
|
|
|
Joined: Aug 2005
Posts: 908
Member
|
Member
Joined: Aug 2005
Posts: 908 |
Have you had the "opportunity" to test restoring the CCS databases? Are the databases viewed as corrupted by CCS? I'm a big proponent of learning from other's misfortunes.
|
|
|
|
Joined: Aug 2005
Posts: 6,692
Member
|
Member
Joined: Aug 2005
Posts: 6,692 |
I have restored many MS Access databases using it, but I have never restored the CCS databases.
One easy way to find out.
|
|
|
|
Joined: Jul 2005
Posts: 79
Member
|
Member
Joined: Jul 2005
Posts: 79 |
Keep in mind that the CCS Server does an auto archive of the DB at 12AM every evening. If you make sure and perform the backup after this time frame and only backup the archived folders not the HADAY or HCDAY then you should be okay. Keep in mind that this would assume that the users only have real-time open or reporter without any reports open so that auto reporter can run.
|
|
|
|
Joined: Aug 2005
Posts: 908
Member
|
Member
Joined: Aug 2005
Posts: 908 |
This is me kicking myself. The backup files have the .src extension correct? I had to use one of those files during a restore. All I had to do was change the extension back to .mdb.
THANK YOU!
|
|
|
|
Joined: Aug 2005
Posts: 908
Member
|
Member
Joined: Aug 2005
Posts: 908 |
Oh well, so much for a good idea. The CCS manual tells you which files to backup, they just don't give you any warnings about the repercussions of backing up an open file. We already backup the entire Avdap folder on the voicemail server. Which files should be backed up on the call processor server?
|
|
|
Forums84
Topics94,518
Posts639,974
Members49,850
|
Most Online5,661 May 23rd, 2018
|
|
2 members (justbill, sbdcomm),
301
guests, and
49
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|