• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1000
  • Last Modified:

Can I use BackupExec to backup the Citrix Access database?

Hello,

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.

Thanks,
OLMECIAN
0
OLMECIAN
Asked:
OLMECIAN
  • 3
  • 2
1 Solution
 
Carl WebsterCommented:
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.
0
 
OLMECIANAuthor Commented:
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.
0
 
Carl WebsterCommented:
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.
0
 
OLMECIANAuthor Commented:
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.
0
 
Carl WebsterCommented:
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.
0
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

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now