1. DL manuals
  2. TANDBERG
  3. Other
  4. TMS SQL DATABASE
  5. Configuration Manual

TANDBERG TMS SQL DATABASE Configuration Manual

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...