I made a backup VIA the web UI 2008 MSSQL backend and and attempting to restore with the command line to 2012 MSSQL and the restore fails due to detecting two system tables :
D:\TeamCity\bin>maintainDB.cmd restore -F D:\ProgramData\JetBrains\TeamCity\backup\TeamCity_Backup_20130805_085302 -T D:\software\prodbackup\TeamCity_Backup_20130805_085302\config\database.properties
TeamCity maintenance tool. Copyright 2010 JetBrains s.r.o. All Rights Reserved.
Command line arguments: restore -F D:\ProgramData\JetBrains\TeamCity\backup\Team
City_Backup_20130805_085302 -T D:\software\prodbackup\TeamCity_Backup_20130805_0
Using TeamCity data directory: D:\ProgramData\JetBrains\TeamCity
Restoring from backup file: D:\ProgramData\JetBrains\TeamCity\backup\TeamCity_Ba
Backup created by TeamCity version:
Build number: 15857
Data format version: 418
Using explicitly specified target database settings: D:\software\prodbackup\Team
Using target database
database type: MSSQL
database driver: <not specified>
login as: <empty>
Connected to the Target DB successfully.
Cannot proceed with 'restore' command: Target database is not empty. Found 2 tab
les: trace_xe_action_map, trace_xe_event_map.
Critical error has occurred during command execution.
I have tried in 90 compatablity mode same results, this is system tables that this is detecting I am not able to drop those tables.
Any help would be appreciated.
This is a 2012 issue, I was able to restore to 2005 with no issues.
Message was edited by: Kyle Jones