[THIN] Re: Move SQL Data Store
- From: "Jeff Durbin" <techlists@xxxxxxxxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Tue, 12 Oct 2004 11:12:33 -0700
Actually, you don't have to use DSMAINT MIGRATE because you're going from
SQL to SQL. Migration is only necessary if you're changing database
platforms. Regarding the procedure, if the credentials to the database are
the same, I think the process that's outlined might actually work. However,
the official procedure is:
1. Backup the datastore database on the origianl server and restore it to
the new server
2. Create a new DSN file that points to the database on the new server.
3. Configure the servers to use the new DSN file with DSMAIN CONFIG
4. Restart the IMA
5. Check that the correct DSN file is in use at
HKLM\Software\Citrix\IMA\DataSourceName
JD
> -----Original Message-----
> From: thin-bounce@xxxxxxxxxxxxx
> [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Shonk, Joe - Perot
> Sent: Tuesday, October 12, 2004 11:02 AM
> To: thin@xxxxxxxxxxxxx
> Subject: [THIN] Re: Move SQL Data Store
>
> Ugh, no... Read through the Admin Guide and Advanced Admin
> Guide for XP.
> You will want to Use DSMAINT to migrate the Data Store and
> also to repoint the Citrix server to the new SQL server.
>
> Joe
>
> -----Original Message-----
> From: Rob Beekmans [mailto:robbeekmans@xxxxxxxxxxxxx]
> Sent: Tuesday, October 12, 2004 10:44 AM
> To: thin@xxxxxxxxxxxxx
> Subject: [THIN] Re: Move SQL Data Store
>
> The plan right now is to backup the existing DB.
> Restore it to the new SQL server.
> Change the file server name, in the file DSN, to point to the
> new SQL server, on each Citrix server in the farm.
> ..and restart IMA service...
>
> Make sure the login on the new DB is correct....that's one
> thing you hve to set yourself outside the restore....I think,
> can anyone confirm or deny this?....
> No big deal.....
>
> Any additional thoughts?
>
> Thanks in advance.
>
> *****************************************
> This email and all attachments that may have been included
> are intended only for the use of the party to whom/which the
> email is addressed and may contain information that is
> privileged, confidential, or exempt from disclosure under
> applicable law. If you are not the addressee or the employee
> or agent of the intended recipient, you are hereby notified
> that you are strictly prohibited from printing, storing,
> disseminating, distributing, or copying this communication.
> If you have received this communication in error, please
> contact the Director of Risk/Privacy Management at (216)778-5776.
>
> For a copy of our Notice of Privacy Practices, please visit:
> http://www.metrohealth.org/general/privacy.asp
>
> ********************************************************
> This Weeks Sponsor RTO Software
> Do you know which applications are abusing your CPU and memory?
> Would you like to learn? -- Free for a limited time!
> Get the RTO Performance Analyzer to quickly learn the
> applications, users, and time of day possible problems exist.
> http://www.rtosoft.com/enter.asp?id20
> **********************************************************
> Useful Thin Client Computing Links are available at:
> http://thin.net/links.cfm
> ***********************************************************
> For Archives, to Unsubscribe, Subscribe or set Digest or
> Vacation mode use the below link:
> http://thin.net/citrixlist.cfm
>
> ********************************************************
> This Weeks Sponsor RTO Software
> Do you know which applications are abusing your CPU and memory?
> Would you like to learn? -- Free for a limited time!
> Get the RTO Performance Analyzer to quickly learn the
> applications, users, and time of day possible problems exist.
> http://www.rtosoft.com/enter.asp?id=320
> **********************************************************
> Useful Thin Client Computing Links are available at:
> http://thin.net/links.cfm
> ***********************************************************
> For Archives, to Unsubscribe, Subscribe or set Digest or
> Vacation mode use the below link:
> http://thin.net/citrixlist.cfm
>
> ********************************************************
> This Weeks Sponsor RTO Software
> Do you know which applications are abusing your CPU and memory?
> Would you like to learn? -- Free for a limited time!
> Get the RTO Performance Analyzer to quickly learn the
> applications, users, and time of day possible problems exist.
> http://www.rtosoft.com/enter.asp?id=320
> **********************************************************
> Useful Thin Client Computing Links are available at:
> http://thin.net/links.cfm
> ***********************************************************
> For Archives, to Unsubscribe, Subscribe or set Digest or
> Vacation mode use the below link:
> http://thin.net/citrixlist.cfm
>
********************************************************
This Weeks Sponsor RTO Software
Do you know which applications are abusing your CPU and memory?
Would you like to learn? -- Free for a limited time!
Get the RTO Performance Analyzer to quickly learn the applications, users,
and time of day possible problems exist.
http://www.rtosoft.com/enter.asp?id=320
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm
Other related posts:
