Friday, January 22, 2016

Difference Between Incident and Problem and Change:-



Difference Between Incident and Problem and Change:-

ITIL process--> information technology infrastructure library

What is an Incident?

A)    An incident is something that needs to be resolved immediately. This can either be through a permanent fix, a workaround or a temporary fix.

Ex:-  Disk space issue, Backup failure and job failure and SQL Server Restarted…..

 What is a Problem?

A) If a incident is repeatedly occurring then we can consider it as a problem. Problems however are not incidents. An incident can raise a problem, especially if there is a high possibility that the incident might happen again.

 Ex:- If a disk space occurs every day, then we can consider this as a problem, and we can work for permanent fix.

What is a Change?

A)     If  you want perform any modification  on the configuration settings in SQL Server, we require a change. The primary objective of Change Management is to enable beneficial Changes to be made, with minimum disruption to IT Services.

        Ex:-   1. Installing a new  SQL Server.

               2. Applying a patch for SQL Server ( required business approval )..like all the implementation in   SQL server will comes under  Change management.

How to connect the Server in realtime in Diff environments



HOW TO CONNECT THE SERVER IN DIFF ENVIRONMENTS
=================================================
1. product based

how to connect the server-->run-->MSTSC--> remote desktop connection.
here provide full server name or IP address(run-->ipconfig) to connect the server.
[or] ssms which is installed in u r machine.

2. service based.

how to connect the client network.

2 ways -->1. CISCO VPN (virtual proviate n/w)
          2. CITRIX.

connecting the network:-In cisco vpn--> click connect--> provide username and pwd.-->ok
connecting the server--> run-->MSTSC--> remote desktop connection.

CITRIX
======
open u r citrix website address--> provide ur username and pwd.
connecting the server--> click on remote desktop icon-->provide servername to connect.

COMMON SQL SERVER BACKUP FAILURE ERRORS AND ISSUES

  One of the most common task for a DBA’s are to perform installation of new SQL Server versions and installing patches. Most often or not e...