Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

moving data store

Status
Not open for further replies.

sajmo

IS-IT--Management
Jan 26, 2003
8
GB
We want to move the data store from the SQL 7 server to SQL2000. The Metaframe Server is on Win2000. How do we detach and then reattach the data store to the SQL2000 server. Has anyone done this?.....and what are the steps involved ...Thanks
 
You can use dsmaint - the procedures are outlined in the MetaFrame XP Admin guide.

Hope this helps CitrixEngineer@yahoo.co.uk
 
I have backed up an ima datastore and restored it to a different sql server with the same name, I used the following procedure:

1. backup IMA_Datastore from old server
2. copy to new server
3. create blank IMA_datastore
4. create SQL security “Citrix” user, ensuring same password as old server
5. restore IMA_Datastore from old server
NOTE: do not use the “Force restore over existing db”

I imagine all you would need to do for the server to have a different name would be to change it in the data sources on each citrix box.

Perhaps some others guys would like to mark this before you do it? i just have a bit more confidence in something that isnt 6 lines of one instruction!

pritch5000

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top