- DL manuals
- TANDBERG
- Other
- TMS SQL DATABASE
- Configuration Manual
TANDBERG TMS SQL DATABASE Configuration Manual - page 10
Tips category – General
Cisco TMS Database Knowledge Tips
Page 10 of 35
TIP T105 –Cisco TMS database and files
Cisco TMS Versions
SQL Server Versions
All
SQL 2000 – All Versions
MSDE 2000 – All Versions
SQL 2005 – All Versions
SQL 2005 Express – All Versions
The Cisco TMS database is installed and maintained by the Cisco TMS installer. Since Cisco TMS v9.0
– the Cisco TMS database is named tmsng . The database consists of two files, a data file and log file –
tmsng.mdf and tmsng_log.ldf respectively. These files will be created in the default data directory of the
SQL Server. For default installations this will be:
For MSDE/SQL 2000 Servers - C:\Program Files\Microsoft SQL Server\MSSQL\Data
SQL Server 2005 Express is installed as the named instance \SQLTMS . The data directory is -
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\MSSQL.1\MSSQL\DATA
The Cisco TMS data and log files may not be directly manipulated as long as the database is attached to
the SQL Server. All interaction must be through the SQL Server interface. To work with the files directly,
the database should be detached from the SQL Server (removing the database from the server without
deleting it).
Summary of TMS SQL DATABASE
Page 1
Cisco tms sql database product configuration guide december 2010 d14216.01.
Page 2: Table Of Contents
Table of contents cisco tms database knowledge tips page 2 of 35 table of contents tip format .................................................................................................................................................... 5 tip t100 –different types of sql server ..................
Page 3
Table of contents cisco tms database knowledge tips page 3 of 35 pros ................................................................................................................................................... 29 cons .............................................................................
Page 4: Document Revision History
Document revision history revision 1.0 initial release of document revision 1.1 applied cisco techdocs template, product names changed, tandberg references changed to cisco revision 1.2 applied new cisco product names revision 1.3 2 nd stage rebranding.
Page 5: Introduction
Introduction cisco tms database knowledge tips page 5 of 35 introduction this document is a collection of various tips for cisco telepresence management suite (cisco tms) administrators working with sql backend databases. Because cisco tms uses a standard sql server for its database, there are many ...
Page 6: Tips Category – General
Tips category – general cisco tms database knowledge tips page 6 of 35 tips category – general tip t100 –different types of sql server cisco tms versions sql server versions all sql v7 – all versions msde – all versions sql 2000 – all versions msde 2000 – all versions sql 2005 – all versions sql 200...
Page 7
Tips category – general cisco tms database knowledge tips page 7 of 35 tip t101 –sql server management tools cisco tms versions sql server versions all sql v7 – all versions msde – all versions sql 2000 – all versions msde 2000 – all versions sql 2005 – all versions sql 2005 express – all versions m...
Page 8
Tips category – general cisco tms database knowledge tips page 8 of 35 tip t103 –sql versions bundled with cisco tms cisco tms versions sql server versions all n/a to simplify installation for cisco tms customers, the cisco tms installer as an option would install a free version of the sql server en...
Page 9
Tips category – general cisco tms database knowledge tips page 9 of 35 tip t104 –cisco tms sql version compatibility cisco tms versions sql server versions all sql 2000 – all versions msde 2000 – all versions sql 2005 – all versions sql 2005 express – all versions the sql server versions supported f...
Page 10
Tips category – general cisco tms database knowledge tips page 10 of 35 tip t105 –cisco tms database and files cisco tms versions sql server versions all sql 2000 – all versions msde 2000 – all versions sql 2005 – all versions sql 2005 express – all versions the cisco tms database is installed and m...
Page 11
Tips category – general cisco tms database knowledge tips page 11 of 35 tip t106 –the sql server instance cisco tms versions sql server versions all sql 2000 – all versions msde 2000 – all versions sql 2005 – all versions sql 2005 express – all versions sql servers are installed as the default insta...
Page 12
Tips category – general cisco tms database knowledge tips page 12 of 35 tip t107 – identifying the sql server instance name cisco tms versions sql server versions all sql 2000 – all versions msde 2000 – all versions sql 2005 – all versions sql 2005 express – all versions if you do not know the sql s...
Page 13
Tips category – general cisco tms database knowledge tips page 13 of 35 tip t108 –sql authentication modes cisco tms versions sql server versions all sql v7 – all versions msde – all versions sql 2000 – all versions msde 2000 – all versions sql 2005 – all versions sql 2005 express – all versions whe...
Page 14
Tips category – general cisco tms database knowledge tips page 14 of 35 tip t109 –when do i need a full version of sql? Cisco tms versions sql server versions cisco tms 11 and newer sql 2000 – all versions msde 2000 – all versions sql 2005 – all versions sql 2005 express – all versions cisco tms shi...
Page 15
Tips category – general cisco tms database knowledge tips page 15 of 35 tip t109 –using osql for cisco tms tasks cisco tms versions sql server versions all sql v7 – all versions msde – all versions sql 2000 – all versions msde 2000 – all versions sql 2005 – all versions sql 2005 express – all versio...
Page 16
Tips category – general cisco tms database knowledge tips page 16 of 35 -d database specify the database to connect to. Equivalent to saying ‘use databasename’. For cisco tms operations, you will almost always specify the tmsng database examples: -d tmsng connect to database named tmsng -q “query” e...
Page 17
Tips category – networking cisco tms database knowledge tips page 17 of 35 tips category – networking tip t200 –enabling remote access to sql cisco tms versions sql server versions 11.0 or newer sql 2005 – all versions sql 2005 express – all versions sql server 2005 installs in a secure fashion that...
Page 18
Tips category – networking cisco tms database knowledge tips page 18 of 35 tip t201 –sql server 2005 and firewalls cisco tms versions sql server versions 11.0 or newer sql 2005 – all versions sql 2005 express – all versions sql server 2005 requires one tcp port per named instance. Named instances by...
Page 19
Tips category – networking cisco tms database knowledge tips page 19 of 35 extra reference links how to: configure a firewall for sql server access how to: configure a server to listen on a specific tcp port.
Page 20
Tips category – networking cisco tms database knowledge tips page 20 of 35 tip t202 –sql server 2000 and firewalls cisco tms versions sql server versions cisco tms 9.0 through 11.9.1 sql 2000 – all versions msde 2000 – all versions sql server 2000 requires one tcp port per named instance. The first ...
Page 21
Tips category – networking cisco tms database knowledge tips page 21 of 35 extra reference links how to configure an instance of sql server to listen on a specific tcp port or a dynamic port.
Page 22
Tips category – maintaining/upkeep cisco tms database knowledge tips page 22 of 35 tips category – maintaining/upkeep tip t300 –backing up the cisco tms database using osql cisco tms versions sql server versions all sql 2000 – all versions msde 2000 – all versions sql 2005 – all versions sql 2005 ex...
Page 23
Tips category – maintaining/upkeep cisco tms database knowledge tips page 23 of 35 tip t301 –restoring the cisco tms database using osql cisco tms versions sql server versions all sql 2000 – all versions msde 2000 – all versions sql 2005 – all versions sql 2005 express – all versions a database can ...
Page 24
Tips category – maintaining/upkeep cisco tms database knowledge tips page 24 of 35 restore databasename from disk = ‘filename’ with move ‘file’ to ‘path\filename’, move ‘file’ to ‘path\filename’ if the new server’s data directory is d:\databases the command syntax to restore the backup to the new fo...
Page 25
Tips category – maintaining/upkeep cisco tms database knowledge tips page 25 of 35 tip t302 –automating backups with sql 2005 express cisco tms versions sql server versions cisco tms 11.0 or newer sql 2005 – all versions sql 2005 express – all versions sql 2005 express can be managed with the sql ma...
Page 26
Tips category – maintaining/upkeep cisco tms database knowledge tips page 26 of 35 13. Click ok. If prompted, supply the password for the account again extra reference links expressmaint website.
Page 27
Tips category – maintaining/upkeep cisco tms database knowledge tips page 27 of 35 tip t303 –detaching and reattaching databases cisco tms versions sql server versions all sql 2000 – all versions msde 2000 – all versions sql 2005 – all versions sql 2005 express – all versions a set of database files...
Page 28
Tips category – maintaining/upkeep cisco tms database knowledge tips page 28 of 35 tip t304 –upgrading msde 2000 to sql 2005 express cisco tms versions sql server versions cisco tms v9.0 and newer sql 2000 – all versions msde 2000 – all versions sql 2005 – all versions sql 2005 express – all version...
Page 29
Tips category – maintaining/upkeep cisco tms database knowledge tips page 29 of 35 16. For error reporting, leave the defaults and click next 17. Click install on the summary page to start the installation. Wait for the installation to complete and click finish 18. Move the tmsng.Mdf file you backed...
Page 30
Tips category – maintaining/upkeep cisco tms database knowledge tips page 30 of 35 quicker cons requires you complete the installation of sql server steps manually instead of automated keeps older instance name – will not be in line with cisco tms defaults going forward less chance for reconfigurati...
Page 31
Tips category – maintaining/upkeep cisco tms database knowledge tips page 31 of 35 statistics section near the end of this tip to create a sql script to perform the task. Return here when completed. 16. You should restart the cisco tms server to allow all services the chance to reconnect to the sql ...
Page 32
Tips category – maintaining/upkeep cisco tms database knowledge tips page 32 of 35 12. The next screen prompts you for your release and option keys. Do not enter any keys and click next. You will be warned this will leave the server in trial mode. Acknowledge the warning and continue. 13. The next s...
Page 33
Tips category – maintaining/upkeep cisco tms database knowledge tips page 33 of 35 from sysobjects where xtype = 'u' order by name open c1 fetch next from c1 into @table_name while @@fetch_status = 0 begin print(@table_name) dbcc dbreindex (@table_name, '') fetch next from c1 into @table_name end pr...
Page 34
Tips category – maintaining/upkeep cisco tms database knowledge tips page 34 of 35 tip t305 –resetting/changing/forgotten sa password cisco tms versions sql server versions all sql 2000 – all versions msde 2000 – all versions sql 2005 – all versions sql 2005 express – all versions if the sa password...
Page 35
Tips category – maintaining/upkeep cisco tms database knowledge tips page 35 of 35 the specifications and information regarding the products in this manual are subject to change without notice. All statements, information, and recommendations in this manual are believed to be accurate but are presen...