Cisco tms sql database product configuration guide december 2010 d14216.01.
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 ..................
Table of contents cisco tms database knowledge tips page 3 of 35 pros ................................................................................................................................................... 29 cons .............................................................................
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.
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 ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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.
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 ...
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.
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...
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 ...
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...
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...
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.
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...
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...
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...
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...
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 ...
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...
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...
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...
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...