cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
306
Views
0
Helpful
2
Replies

Backup and Restore TMSPE question

Is there a way to backup just the TMSPE data from a 14.3 system and restore the users and schema templates to a 15.3 system?

1 Accepted Solution

Accepted Solutions

Patrick Sparkman
VIP Alumni
VIP Alumni

We use SQL Server Management Studio to backup and restore our databases.

Data is stored in several databases depending on the TMSPE features you've installed, you may or may not have all of these, but you'll want to backup the following:

  • tmspe
  • tmspe_vmr
  • tms_userportal

View solution in original post

2 Replies 2

Patrick Sparkman
VIP Alumni
VIP Alumni

We use SQL Server Management Studio to backup and restore our databases.

Data is stored in several databases depending on the TMSPE features you've installed, you may or may not have all of these, but you'll want to backup the following:

  • tmspe
  • tmspe_vmr
  • tms_userportal

we will try to get just these three.  there was some corruption in the whole data bases.

thanks

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: