Solved

Can I use BackupExec to backup the Citrix Access database?

Posted on 2008-10-10
5
981 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

#Citrix #Internet Explorer #Enterprise Mode #IE 11 #IE 8
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
In this Micro Tutorial viewers will learn how they can get their files copied out from their unbootable system without need to use recovery services. As an example non-bootable Windows 2012R2 installation is used which has boot problems.
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.

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now