Citrix Presentation Server 4.5, lost database server with IMA database - what to do?

Posted on 2011-10-17
Last Modified: 2012-05-12
OK - I am working on a Citrix server farm (5 servers) where a separate server containing the IMA database suffered TWO hard drive failures at the same time. (so much for RAID 5) The server that died was also the backup server for the network.

I rebuilt the server and reloaded Backup Exec 12.5 and cataloged the last good backup cartridge. Backups were run on the server, but they did not have the SQL server agent on this server. It looks like backup exec just skips over the mdf and ldf files and doesn't even try to back them up.

If I look at the MF20.dsn file on one of the Citrix servers it looks like this:

APP=Citrix IMA
Description=Citrix Database

On the server that had the database, under the Microsoft SQL Server folder in Program files, I see a folder named MSSQL$SQLLICENSES - but under the Data folder I do not see any recent .mdf or .ldf files named "Citrix".

The farm is running fine, people are logging in and running apps. However, nothing can be managed because the Access Management Console will not run.

I did some searches and it looks a if I need to reload Citrix and re-publish all the apps to get everything back 100%.

OR - is there a way to fix this without having to rebuild the farm. Am I looking in the right place for the database files?

Any help or suggestions will be appreciated.

Question by:CTrenton
    LVL 24

    Expert Comment

    by:Sekar Chinnakannu
    Can you try to restore the datastore DB from backup and give a try to resolve this issue.

    Author Comment

    It doesn't look as if the backups actually backed up the database files. They use backup exec 12.5 and they did not have a license for the SQL server agent on that server.

    I am not a Citrix expert, nor an SQL server expert. It looks as if the farm needs to be rebuilt.

    Do I use the chfarm command to create the new farm and then run this on the other servers to join the new farm?

    I understand I will lose all published apps, custom load evaluators, etc.
    LVL 24

    Expert Comment

    by:Sekar Chinnakannu
    In this case I think you have go for new farm or give a try from data collector to join the server in same farm. Not sure it will work 100% you can give a try. Same time try take all your app details and farm config details.

    Check our expert update too, Hope you will get some idea now
    LVL 14

    Accepted Solution

    I hate to break it to you, but once your database is gone, there's nothing you can do.  The console relies on data from the IMA database, that's why you can't even open up the console.  So sorry.

    Yes, you can use CHFARM to initiate your new farm and then have other servers rejoin this new farm.  

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Citrix XenDesktop, Citrix Studio, Citrix Policies, Citrix XenApp
    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.
    How to install and configure Citrix XenApp 6.5 - Part 1. In this video tutorial we have explained step by step installation of Citrix XenApp 6.5 Server on Windows Server 2008 R2 is explained in this video. We have explained the difference between…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…

    760 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

    12 Experts available now in Live!

    Get 1:1 Help Now