Warning
Potential for Data Loss: The steps detailed in the resolution of this article may result in a loss of critical data if not performed properly. Before beginning these steps, make sure all important data is backed up in the event of data loss. If you are unsure or unfamiliar with any complex steps detailed in this article, please contact Product Support Services for assistance.
Issue
- How to restore and view a Log backup without overwriting current database
- How to view backed-up events without overwriting current database
- How to restore a SQL database without overwriting current database
Environment
TAC Vista 4.3 and higher running a typical (not custom) SQL.
Cause
The event and logs will be backed up as a SQL backup file. This means that restoring a backup on the same PC that it was made on replaces the SQL database.
Resolution
To view old data, restore the log database backup file on a different PC that has the same TAC Vista database on it.
- Create a copy of the TAC Vista database (or make a backup)
- Copy / restore the database to a computer that is running the same version of TAC Vista
- Go to the Server application and log in
- Go to File > Restore Log Database
- Browse in the backup file, the path should be filled in automatically