[THIN] Re: Data Store Move
- From: "Hamilton, Ronnie" <ronnie.hamilton@xxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Wed, 26 Oct 2011 08:14:00 +0100
That would be great
thanks
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
Behalf Of Berny Stapleton
Sent: 25 October 2011 19:07
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Data Store Move
sp_change_users_login I think is what you are thinking of Raff.
It's more relevant when you are using SQL authentication.
Ronnie, I'm going to have a go at sanitising a doc which I did on IMA DB
migrations and I'll send it over to you when I'm done.
Berny
On Tue, Oct 25, 2011 at 6:46 PM, Raffensberger, Stephen D <
sraffens@xxxxxxxxxxx> wrote:
Okay, I'm old so maybe this is no longer relevant or maybe you included
it inside "Restore to MSSQL Express server"..
I seem to remember real database admins (not me) saying that if you move
a SQL database from one machine to another with a different hostname,
you must do some fancy footwork to make it run there because the old
hostname is buried somewhere within the database and it checks when it
starts up.
Just a thought.
Raff
Steve Raffensberger
Citrix Administrator
Produban US
sraffens@xxxxxxxxxxx
________________________________
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
Behalf Of Hamilton, Ronnie
Sent: Monday, October 24, 2011 9:00 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Data Store Move
All,
I have tried to move our data store from an SQL server to a MSQL Express
server. They are very similar versions but due to licencing issues with
CALs I have to move it.
Move of what I had read this seemed quite straight forward.
Steps taken :
Backup database
Restore to MSQL Express server
Change the ODBC connection pointers to new server
Restart the XenApp server
Repeat for all servers.
When I log on to the server and start the console it fails. This
happened on all the servers.
When this happened I changed all the odbc connections back and restarted
all the servers.
Should I have been recreating the LHC on each server ?
Thanks
Ronnie
Ronnie Hamilton
Senior Network Engineer
Lufthansa Technik Airmotive Ireland
IT Department
Naas Road, Rathcoole
Co. Dublin, Ireland
Phone: +353 1 401 1253
E-mail: ronnie.hamilton@xxxxxxx <mailto:ronnie.hamilton@xxxxxxx>
www.ltai.ie
Visit our website : www.ltai.ie
__________________________________________
Lufthansa Technik Airmotive Ireland Limited. Registered in Ireland. Reg.
No. 45999. Registered Office: Naas Road, Rathcoole, Co.Dublin.
Lufthansa Technik Airmotive Ireland Leasing Limited. Registered in
Ireland. Reg. No. 140891. Registered Office: Naas Road, Rathcoole,
Co.Dublin.
__________________________________________
The information in this email and in any attachments is confidential and
may be privileged. If you are not the intended recipient, please destroy
this message, delete any copies held on your systems and notify the
sender by return email. You should not read, retain, copy, disseminate,
distribute, disclose or use this email or its contents in any way. Any
such action is strictly prohibited. Thank you.
Other related posts:
