Cisco TMS SQL DATABASE

To Next Page

To Previous Page

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

Main Page

Table of Contents2
Tip Format5
TIP T100 -Different Types of SQL Server6
- Extra Reference Links6
- TIP T101 -SQL Server Management Tools7
- Extra Reference Links7
TIP T103 -SQL Versions Bundled with Cisco TMS8
TIP T104 -Cisco TMS SQL Version Compatibility9
TIP T105 -Cisco TMS Database and Files10
TIP T106 -The SQL Server Instance11
TIP T107 - Identifying the SQL Server Instance Name12
TIP T108 -SQL Authentication Modes13
- Extra Reference Links13
Tip T109 -When Do I Need a Full Version of SQL14
- Extra Reference Links14
TIP T109 -Using Osql for Cisco TMS Tasks15
- Simple Examples for Cisco TMS Use16
- Extra Reference Links16
TIP T200 -Enabling Remote Access to SQL17
- Extra Reference Links17
TIP T201 -SQL Server 2005 and Firewalls18
- Possible Scenarios18
- Using Windows Firewall for a Single Instance18
- Using Windows Firewall for Multiple Instances18
- Extra Reference Links19
TIP T202 -SQL Server 2000 and Firewalls20
- Possible Scenarios20
- Using Windows Firewall for Single Instance20
- Using Windows Firewall for Multiple Instances20
- To Find the Port a SQL Server Instance Is Currently Using20
- Extra Reference Links21
TIP T300 -Backing up the Cisco TMS Database Using Osql22
- Extra Reference Links22
TIP T301 -Restoring the Cisco TMS Database Using Osql23
- Restoring a Database to the same SQL Server23
- Restoring a Database to a Different SQL Server23
- Extra Reference Links24
TIP T302 -Automating Backups with SQL 2005 Express25
- Extra Reference Links26
TIP T303 -Detaching and Reattaching Databases27
- To Detach the Cisco TMS Database Using Osql27
- To Attach the Cisco TMS Database Using Osql27
- Extra Reference Links27
TIP T304 -Upgrading MSDE 2000 to SQL 2005 Express28
- Cisco TMS Customers Running MSDE 2000 and Cisco TMS Versions 9.0 through 10.028
- Cisco TMS Customers Running MSDE 2000 and Cisco TMS Versions 11.0 through 11.9.129
- Alternative 1 - Install SQL Server Manually29
- Pros29
- Cons30
- Alternative 2 - Use Cisco TMS Installer to Install SQL Server31
- Pros31
- Cons31
- SQL Code to Update Indexes and Statistics32
- Extra Reference Links33
TIP T305 -Resetting/Changing/Forgotten Sa Password34
- Extra Reference Links34
- Table of Contents Page 2 of35

Table of Contents

Related product manuals