Skip to content

Troubleshooting

Please find in this document, a list of different resources to find out more information about any failure using the Delphix Select Connector for MSSQL Server:

** SQL Server VDBs(Provisioning) plugin log files: **

<DLPX_CONNECTOR_PATH>\SqlServer Manual Discovery\logs\<Name of the VDB>\debug.log

** Delphix Environment discovery logs: **

<DLPX_CONNECTOR_PATH>\SqlServer Manual Discovery\logs\debug.log

** SQL Server dSource(Linking) plugin log files: **

<DLPX_CONNECTOR_PATH>\SqlServer Manual Discovery\<StagingDBName>\logs\debug.log

** MSSQL Server DB queries: **

  • Execute the below command to list database version:
SELECT @@VERSION[server], SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
  • Execute below commands to get OS details where SQL Server database is running.
sp_server_info
select @@version
  • Execute below command to get the status of all SQL Server database running on server.
SELECT name, state_desc FROM  sys.databases
  • Verify the status of SQL Server database backup start and end time.
select top 10 b.database_name, b.backup_start_date, b.backup_finish_date from msdb.dbo.backupset b
  • Verify the log shipping status for SQL Server database.
use master;
sp_help_log_shipping_monitor

  • SQL Server Error Log

    • The Error Log, SQL Server’s most important log file, is used to troubleshoot all general system problems.

    • To view the Error log, use either one of two methods:

    • Windows Explorer: Browse to the “%ProgramFiles%\Microsoft SQL Server\MSSQL.1MSSQL\LOG\ERRORLOG” directory and view the logs, named “ERRORLOG.X”, using a third party log or document viewer.

    • SQL Server Management Studio: Expand the server node, expand Management, and click SQL Server Logs:

  • Windows Event Log

    *An important source of information for troubleshooting SQL Server errors, the Windows Event log contains three useful logs.

    * To view the Windows Event log, go to Administrative Tools, Event Viewer.