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"}}]
Was this topic helpful?
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