Cisco Backup and Recovery of the TMS database
Cisco TMS redundancy configuration and overview
Page 30 of 32
SQL server named ACME\WIDGETS from a backup file c:\tmsbackup.bak enter the following
command in a command window on the database server
osql –U sa –S ACME\WIDGETS –Q “restore database tmsng from disk =
‘c:\tmsbackup.bak’”
You will be prompted for the password to the sa account and then the restore will execute.
Note: If the SQL server is installed as a named instance or part of a cluster, you will have to specify
the SQL server name or address in the osql command as shown in the example. If the server is the
default instance, you can omit the –S option and server name.
A database named tmsng must exist on the SQL server before you can restore from a backup
A database backup includes the file paths used for the database. If for some reason the database
files are in a different location from when the backup was taken, you must use the MOVE options with
the restore commands. Please see the Microsoft SQL documentation for help using the MOVE
option.
