All TMS data is stored within the tmsng SQL database, depending on how TMS was intsalled, the database could be on the TMS server itself or on an external SQL server. You can use SQL Server Management Studio for example to connect to and perform a backup of the database, as well as restore from a backup if needed.
Back Up and Restore of SQL Server Databases