IBM Support

Determining SQL Server instance name to use with Data Protection for SQL.

Troubleshooting


Problem

The SQL Server instance name is needed for Data Protection for SQL Server with backup/restore scenarios.

Resolving The Problem

The following SQL Server command can be run against the SQL Server to determine the SQL Server instance name that is installed:


osql -E -Q "select @@servername"

This needs to be run from the Microsoft Sql Server installation directory. For example :

C:\Program Files\Microsoft SQL Server\90\Tools\Binn>osql -E -Q "select @@servername"
--------------------------------------------------------------------------
XXYYZZ21
(1 row affected)
SQL Server Instance name is XXYYZZ21
[{"Product":{"code":"SSTFZR","label":"Tivoli Storage Manager for Databases"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Data Protection for MS SQL","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"Standard","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

More support for:
Tivoli Storage Manager for Databases

Software version:
All Versions

Operating system(s):
Windows

Document number:
86319

Modified date:
17 June 2018

UID

swg21247341