Can I use BackupExec to backup the Citrix Access database?

Posted on 2008-10-10
Medium Priority
Last Modified: 2012-08-13

I'm trying to put together a Disaster Recovery plan for our Citrix farm. We are running Citrix Presentation Server 4.5 w/ the latest Service Packs. We still use the default Access database (mf20.mdb).

We are using BackupExec 10d Rev. 5629 w/ SQL and Open File agents.

I setup a "BackupToDisk" device (a shared folder that resides on another Citrix server). I created a daily backup job using this B2D device, which copies the entire Citrix IMA directory to this location.

The job is quick, takes about 30 seconds (it's less than 10 MB of data) and is always successful.

Is this a support way of backing up the IMA folder and the DB files that reside within it?

I realize that there is a special "dsmaint backup" command that I can run... But this also seems to be another way to accomplish my goal, only it's easier.

Can someone weigh in and let me know their thoughts on this? The reason why I like the idea of using a BackupExec job is because I can have the daily job log e-mailed to our Backup Review staff to make sure the job is going off successfully.

Question by:OLMECIAN
  • 3
  • 2
LVL 37

Expert Comment

by:Carl Webster
ID: 22688239
You only need the DSN file and the access DB.  I use the dsmaint backup command to backup to a shared folder and also copy the DSN file.  If you ever had to do a DR, those are the only files you would need.  Actually the DSN would be recreated but you lose the access DB and you are sunk.

Author Comment

ID: 22688687
CarlWebster, thank you for the quick reply. I understand your response. I'm just curious to find out though, if backing up those files, with BackupExec, will work. I don't see why it wouldn't... I don't get "in use - skipped" errors or anything like that. Thanks.
LVL 37

Expert Comment

by:Carl Webster
ID: 22688767
There is nothing wrong with backing up the entire folder tree but it gains you nothing.  All you need is the access database file to recover from a disaster or a corrupt DB.  That is why I use a batch file - actually 5 of them.  That way I have 5 copies of the DB (Mon thru Fri).  I have them scheduled to run at a set time, one for each day of the week.

Author Comment

ID: 22688908
What are you using to schedule the various backups? Windows Task Scheduler?

I like that BackupExec can automatically e-mail us the backup job's log file. We do NOT want to have to manually check this every day.

So "dsmaint backup", in and of itself, isn't doing anything special to the MDB files (like compressing it or something), it's simply making a copy in the specified destination?

The ONE question I am trying to get answered, is whether or not the MDB file backed up using BackupExec will be just as "healthy" as the MDB file backed up using DSMAINT... if it, I'm totally cool with our current setup.
LVL 37

Accepted Solution

Carl Webster earned 750 total points
ID: 22688965
yep, just use plain old built-in windows task scheduler.

yep #2, dsmaint just makes a copy.

yep #3, the mdb file is just fine.  BUT I would test it just to be sure.

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question