Connect to SQL Server when you don’t know SA account or don’t have sysadmin access

Below are the steps you need to perform to grant SYSADMIN access to a user in SQL Server in case you are completely locked out. 1. Download PSexec to connect using SQL Server Management Studio using the NT Authority\System Download PsTools from Unzip the content and copy PsExec.exe to

Determine what Linux Version

4 different commands that you can run to see information about your Linux distro. [oracle@server ~]$ cat /etc/issueOracle Linux Server release 6.8 [oracle@server ~]$ cat /etc/*releaseLSB_VERSION=base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarchOracle Linux Server release 6.8NAME=”Oracle Linux Server”VERSION=”6.8″ID=”ol”VERSION_ID=”6.8″PRETTY_NAME=”Oracle Linux Server 6.8″ANSI_COLOR=”0;31″CPE_NAME=”cpe:/o:oracle:linux:6:8:server”HOME_URL=””BUG_REPORT_URL=””ORACLE_BUGZILLA_PRODUCT=”Oracle Linux 6″ORACLE_BUGZILLA_PRODUCT_VERSION=6.8ORACLE_SUPPORT_PRODUCT=”Oracle Linux”ORACLE_SUPPORT_PRODUCT_VERSION=6.8Red Hat Enterprise Linux Server release 6.8 (Santiago)Oracle Linux Server release 6.8 Kernel

Create Data Guard standby using RMAN

Production server – serverProdStandby server – serverStbyProduction database – whseprodStandby database – whsestby Step 1: Using RMAN, Backup the database that includes backup of datafiles, archivelogs and controlfile for standby [oracle@serverProd]$ rman target / connected to target database: whseprod (DBID=123322) RMAN> run { allocate channel disk1 type disk format ‘/backup/whseprod_restore/%d%U’