Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Can I use BackupExec to backup the Citrix Access database?

Posted on 2008-10-10
5
Medium Priority
?
994 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
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.
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 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.
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 37

Accepted Solution

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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

After several days of searching and hunting for limited documentation, I wanted to share this guide to hopefully save someone the hassle of trying to figure this out on their own. I have tested this on Xendesktop 7.1 and PS 4.5 running simultaneous…
#Citrix #XenApp #Citrix Scout #Citrix Insight Services #Microsoft VMMAP #Microsoft ADEXPLORE #Microsoft RAMMAP #Microsoft TCPVIEW #Microsoft AUTORUNS #Microsoft PROCESS EXPLORER #Microsoft PROCESS MONITOR
In this Micro Tutorial viewers will learn how to restore single file or folder from Bare Metal backup image of their system. Tutorial shows how to restore files and folders from system backup. Often it is not needed to restore entire system when onl…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

609 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