May, 2017

Update ESXi 6.0 from CLI on Standalone Host

May 24, 2017 Jordansphere VMware

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/ […]

More

User Already Exists in the Current Database

May 19, 2017 Jordansphere MS SQL

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 :   […]

More

DB migratiion, MS SQL 200, MS SQL 2012, User Already Exists in the Current Database,

Finding IP Address of Device Using Cisco Switch and Router

May 18, 2017 Jordansphere Cisco

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 […]

More

cisco router, cisco switch, find, Locate, mac address,

List Recovery Model and Compatibility Level for MS SQL DB

May 9, 2017 Jordansphere MS SQL

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

More

Powered by WordPress. Designed by elogi.