Products
Webtrends Relocator
Issue
When running the Webtrends Relocator on the destination machine, you receive this error message:
Error restoring databases: Logical file ‘wtmaster’ is not part of database ‘wtmaster_temp’. Use RESTORE FILELISTONLY to list the logical file names. RESTORE DATABASE is terminating abnormally.
Cause
This occurs when the logical file name of the wtMaster database is set to something other than wtMaster on the source machine.
Resolution
To resolve this, you will need to follow these steps:
Gather the wtsource.zip file from the customer. Restore the databases into an instance of Microsoft SQL Server Management Studio that does not already contain the wt_sched and wtMaster databases. Please refer to Backing Up and Restoring the System Database using MS SQL Management Studio for instructions on how to restore a database. Right click on the wtMaster database and choose Properties. Click on Files on the left hand side and make note of the Logical Name. Click on the New Query button and paste in this command:
alter database wtmaster modify file (NAME=‘CURRENT_LOGICAL_NAME’,NEWNAME=‘wtmaster’) Replace CURRENT_LOGICAL_NAME with the Logical Name that we noted previously and Execute the query. Right click on the wtMaster database and choose Properties again. Go under Files and confirm that the Logical Name now only says wtmaster. Repeat steps 3-7, only with wt_sched. Do not forget to change the instances of wtmaster in the query to wt_sched. Once both databases have been repaired, export both databases. You will need to be sure you name the backup files wt_sched.bak and wtmaster.bak. Please refer to Backing Up and Restoring the System Database using MS SQL Management Studio for instructions on how to backup a database. Zip the backup files into a file called wtsource.zip. Have the customer try the Webtrends Relocator again using this wtsource.zip package.