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

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

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:

[ODBC]
DRIVER=SQL Server
UID=Administrator
Trusted_Connection=Yes
DATABASE=Citrix
WSID=CITRIXSERVER02
APP=Citrix IMA
SERVER=SERVERNAME\SQLLICENSES
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.

Thanks!
0
CTrenton
Asked:
CTrenton
  • 2
1 Solution
 
Sekar ChinnakannuSenior EngineerCommented:
Can you try to restore the datastore DB from backup and give a try to resolve this issue.
0
 
CTrentonAuthor Commented:
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.
0
 
Sekar ChinnakannuSenior EngineerCommented:
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 http://www.experts-exchange.com/Software/System_Utilities/Remote_Access/Citrix/Q_23193395.html
0
 
joharderCommented:
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.  
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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