Solved

Can I use BackupExec to backup the Citrix Access database?

Posted on 2008-10-10
5
989 Views
Last Modified: 2012-08-13
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
Comment
Question by:OLMECIAN
  • 3
  • 2
5 Comments
 
LVL 36

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.
0
 

Author Comment

by:OLMECIAN
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.
0
 
LVL 36

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.
0
 

Author Comment

by:OLMECIAN
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.
0
 
LVL 36

Accepted Solution

by:
Carl Webster earned 250 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.
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

#Citrix #Internet Explorer #Enterprise Mode #IE 11 #IE 8
VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …
In this Micro Tutorial viewers will learn how to use Windows Server Backup to create full image of their system. Tutorial shows how to install Windows Server Backup Feature on Windows 2012R2 and how to configure scheduled Bare Metal Recovery backup.…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

733 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