cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
240
Views
0
Helpful
1
Replies

Moving SQL database to another server

sw2244zz
Level 1
Level 1

Hi

 

We have Telepresence Suite 13.x.x and we'd like to move the SQL 2005 database to another SQL server, as the older server is being decomissioned.

 

This Cisco doc seems to indicate we can move the SQL database easily:

https://supportforums.cisco.com/document/108271/migrating-telepresence-management-suite-tms-new-serverpdf


Can I get someone from Cisco to confirm this is basically the correct process to move the SQL database to another SQL server :

 

(1) Shut down app server

(2) Detach and move database to another SQL server & re-attach

(3) Start the app server

(4) Go into TMS Tools on the app server & change the config to point to the new  Database Server\Instance, database name, & re-enter the database Username & Password.

(5) Reboot app server to make it find new SQL Server

 

Is this correct?

 

Thanks in advance.

 

 

 

 

1 Reply 1

Patrick Sparkman
VIP Alumni
VIP Alumni

That's it, pretty simply really.  Since the document you linked to is by Cisco, that should be all you need.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: