[THIN] Re: Data Store server down
- From: "TSguy92 Lan" <tsguy92@xxxxxxxxx>
- To: thin@xxxxxxxxxxxxx
- Date: Thu, 20 Mar 2008 15:13:56 -0700
There are ways to protect your MS Access db all the same however, in the
event that you can't yet move to a SQL backend.
Simple things like having a nightly process to backup your datastore to
another location:
*dsmaint backup \\server\sharename\folder*
If you have an Access DB you'll want to also compact it every so often:
*dsmaint compactdb /DS*
This post from the citrix support forums also covers this question, and has
a solution which might be useful to you.
http://support.citrix.com/forums/thread.jspa?forumID=1&threadID=44779&tstart=0
By default in having your Datastore offline, your citrix servers should have
been able to live off of their Local host cache for at least 48 hours. IE -
they should have been able to continue to allow logins during your datastore
outage. That is unless the server which went offline serves some other
important function in your infrastructure, I don't believe that the server
in question also being the preferred ZDC should have been a show stopper
either...do you not have other zone collectors defined?
MS access within smaller farms can work a treat, but certainly you get
better performance out of having your datastore hosted on an actual DB
server of some nature, and as Rick points out . . it's easy to move it.
The official citrix article on migrating your db...
http://support.citrix.com/article/CTX677542
HTH
Lan
On Thu, Mar 20, 2008 at 2:28 PM, Rick Mack <ulrich.mack@xxxxxxxxx> wrote:
> Hi Hector,
>
> If you've got more than one Citrix server and you want any sort of
> redundancy, then putting the datastore on a proper database (SQL, MSDE, SQL
> Express 2005, Oracle etc) which ISN'T hosted on a Citrix server is kind of
> mandatory.
>
> Migrating/copying the datastore isn't that hard, and MSDE or SQL Express
> 2005 (depending on the number of servers you've got) works perfectly well.
> Just remember to treat the datstore SQL instance like the important data it
> is.
>
> regards,
>
> Rick
>
> --
> Ulrich Mack
> Quest Software
> Provision Networks Division
>
>
> On 3/21/08, Minero, Hector B CIV NSWCDD, K55 <hector.minero@xxxxxxxx>
> wrote:
> >
> > Hi all, today the PS 4.0 Data Store server which is also the zone's
> > preferred data collector went down for an hour and no one could log on to
> > the farm. We're using an Access DB.
> >
> > Other than moving the Data Store to SQL, is there a way to have a
> > failover Access Data Store? Or is it pretty much the way it is designed?
> >
> > _________________________
> > Hector Minero
> > NSWCDD Code K55
> > Ph: 540.653.8859
> > Email: hector.minero@xxxxxxxx
> >
>
>
>
>
Other related posts:
