Link to home
Start Free TrialLog in
Avatar of Korey Davis
Korey DavisFlag for United States of America

asked on

corrupt Databases

hello everyone, last night between 5 and 10 something happened and our database was corrupt.  we have two citrix servers and the database is located on our database server. only a few tables were corrupt. I've checked the event logs and nothing seems to have happened during that time on all three servers. I've also checked the task scheduler to see if something ran around that time. nothing has shown to be a problem. Also, it happened twice exactly a week apart.
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Database backup run weekly? How do you recover?
Avatar of Korey Davis

ASKER

Hello We have backups run nightly and from what i can tell the backups ran normally and have no failures. it was recovered from yesterdays backup.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@Scott McDaniel,  this is J.R. I'm Korey's Director.  I see your post on running the BE on Citrix, and I read the article, but don't see the advantage of placing it on a Citrix server.   Can you elaborate why you feel it's better on a Citrix machine?  

Thanks
Advantage = no network connection. It's as simple as that. The more 'hardware' you put between the FE and BE, the greater your chances of corruption.

One of the biggies on Citrix or RDS is have a correct split architecture, as I mentioned earlier. Users should NOT share the same FE, but should have their own copy of it in their LOCALAPPDATA folder, not on their C drive (which is shared by everyone). The article linked has a nice script that can be used when the Citrix user logs in to do these things for you.
Thanks for the update.   In our environment, we have 2 Citrix servers and 4 locations that connect to them.   The database is stored on a Hyper-V VM and each user has their FE folder.   I do believe the corruption was caused by a network interruption, unfortunately we've not been able to locate the specific cause.

We've had the same configuration for 16 years, so I'm going to stick with what has worked for us.

J.R.
I do believe the corruption was caused by a network interruption
That's the most common reason for db corruption. It's not overly common in a Citrix/RDS environment, but it can happen. As long as you're following the best practices outlined by Gustav in that article you shouldn't have a problem.
Thanks,

J.R.
Network connection issue