TMS Disaster recovery

[Utair Corporation]

Hi.

Is there any document on backing up AND recovery of TMS suite server?

After searching for a while, i have to use MS SQL tools to backup TMS database. Okay, but what should i do in case of disaster? Install fresh server, fresh TMS and overwrite database from backup? Is that all or am i missing something? What about TMSPE ?

[Magnus Ohm · Accepted solution]

It is enough to do a backup of the TMSNG database and the TMSPE database in order to have a backup of you TMS. On the server side you should create an image but this is not necessary for the TMS point of view since the application gets its info from the database so you can just install the application on a new server and connect to the database and your TMS should be up and running again.

Same goes for TMSPE.

You are responsible for taking the backup of the databases.

/Magnus

[Utair Corporation]

Thankyou

[Sumeet Rakesh]

Hi,

If you are using SQL enterprise version, the backup task can be automated else you have to take backup manually.

You can use SQL studio management express or can take backup of using the CLI. Also, during the disaster recovery same version of TMS should be installed as the backup. Below are the CLI to take backup:

Backup for TMSNG database

=========================

sqlcmd -E -S localhost\sqltms -Q "BACKUP DATABASE tmsng TO DISK = 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SQLTMS\MSSQL\Backup\tmsng_backup.bak'"

Backup for TMSPE database

=========================

sqlcmd -E -S localhost\sqltms -Q "BACKUP DATABASE tmspe TO DISK = 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SQLTMS\MSSQL\Backup\tmspe_backup.bak'"

Make sure the path is available else define your own path for backup.

Regards

Sumeet Rakesh