JordansphereMay, 2017
Update ESXi 6.0 from CLI on Standalone Host
In this example I will upgrading from ESXi 6.0 Update 2 to ESXi Update 3 on a standalone host. 1) Check current version: esxcli system version get Output: 2) Download the required file from VMware then upload zip file to temporary directory on the ESXi host. In this case I have created a directory called TEMP-PATCHES/ […]
User Already Exists in the Current Database
Scenario: I was transferring a database (mick) from one SQL2005 server to an SQL2012 server. During the mapping of a user login (mick) I got the following the error: Create failed for User 'mick' User, group, or role 'mick' already exists in the current database Answer: In Studio Management you can use the follwing command : […]
Finding IP Address of Device Using Cisco Switch and Router
Scenario: I had a Raritan PDU that was plugged into a Cisco 2960 switch which in-turn was connected to a Cisco 6506 router. The PDU did not display the IP address and I could see it was plugged into port 24 on the switch. To find out the IP address Log into the […]
List Recovery Model and Compatibility Level for MS SQL DB
Use this query to select the recovery model and compatibility level of a DB on a MS SQL 2005 server. select name, recovery_model_desc, compatibility_level from sys.databases