[THIN] Re: Data Store Move
- From: Magnus Hjorleifsson <magnus@xxxxxxxx>
- To: thin@xxxxxxxxxxxxx
- Date: Tue, 25 Oct 2011 14:09:35 -0400
The way I usually do it is to
SP_detachDB copmmand that [points to the data file and log file
stop the sql services
Copy the mdf and ldf files to the new servers
sp_attachdb with the commands to point to the mdf and ldf files
On Tue, Oct 25, 2011 at 1: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****
>
> [image: Logo Produban] ****
>
> *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 ****
>
> 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:
