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/ Read More…
Month: May 2017
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 : Read More…
Finding IP Address of Device Using Cisco Switch and Router
Issue: 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. Resolution: To find out the IP address Log into Read More…
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