Downloaded 22 times
Uploaded bySunny U Okoro
DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase
This document provides information on database administration (DBA) tasks for various database platforms including MySQL, PostgreSQL, SQL Anywhere, SQL Server, DB2 Express, and Oracle. It discusses topics such as migration, backup, and recovery procedures for each database platform. Sections provide details on migrating from SQL Server 2008 R2 to MySQL, backup and recovery steps for PostgreSQL 9.4, backup procedures for SQL Server 2014, and user and object management for Oracle 11G/12C.
More Related Content
Similar to DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase
DBA Oracle,SQL Server, MYSQL,DB2 Express Postgres & Sybase
- 1. DBA MySQL,Postgres,Oracle,DB2 , Sybase &MSSQL By Sunny U Okoro
- 2. 1 Table of Contents MYSQLDBA ....................................................................................................................................2 Migration....................................................................................................................................3 Backup......................................................................................................................................10 Recovery 1................................................................................................................................13 Recovery 2................................................................................................................................15 PostgreSQL 9.4 DBA..........................................................................................................................18 Backup and Recovery....................................................................................................................19 SQL Anywhere 16 DBA .....................................................................................................................25 SQL Server 2014 DBA ........................................................................................................................32 Backup.........................................................................................................................................32 Recovery......................................................................................................................................34 DB2 Express DBA..............................................................................................................................38 Backup.........................................................................................................................................38 Recovery......................................................................................................................................42 Oracle 11G/12C................................................................................................................................43 User Accounts and Tablespace.......................................................................................................43 Objects Creation...........................................................................................................................45 Objects Verification.......................................................................................................................47
- 3.
- 4.
- 5.
- 6.
- 7.
- 8.
- 9.
- 10.
- 11.
- 12.
- 13.
- 14.
- 15.
- 16.
- 17.
- 18.
- 19.
- 20.
- 21.
- 22.
- 23.
- 24.
- 25.
- 26.
- 27.
- 28.
- 29.
- 30.
- 31.
- 32.
- 33. 32 SQL Server 2014DBA Backup SQL Server2008R2
- 34.
- 35.
- 36.
- 37.
- 38.
- 39.
- 40.
- 41.
- 42.
- 43.
- 44. 43 Oracle 11G/12C User Accountsand Tablespace
- 45.
- 46.
- 47.
- 48.
- 49.
- 50.
- 51.
- 52.