Feroz DBA'S Blog

  Types of backups in the SQL Server   a.      Common types of backups: ·         Full ·         Differential ·         Transaction log ·         Tail log backup b.      Other types of backups: ·         Copy-only backup ·         File backup ·         Partial backup .      Backup Administration   Full Backups It backs up everything. It is a base backup of any database backup. This is also called a complete database backup which includes all of the objects like tables, indexes, views, procedures, functions etc. How to create full database backup: Using T-SQL: BACKUP DATABASE [AdventureWorks2012] TO DISK = 'D:\SQL_backup\full\adventu...

How to connect to postgreSQL database? psql -U postgres output: C:\Users\FEROZ>psql -U postgres Password for user postgres: psql (13.6) WARNING: Console code page (437) differs from Windows code page (1252)          8-bit characters might not work correctly. See psql reference          page "Notes for Windows users" for details. Type "help" for help. How to check postgreSQL version? select version(); output: postgres=# select version();                           version ------------------------------------------------------------  PostgreSQL 13.6, compiled by Visual C++ build 1914, 64-bit (1 row) psql --version psql (PostgreSQL) 13.6 How to check server uptime? Generally postgres stores the start time, and we can see the details by running the below command: SELECT pg_postmaster_start_time(); output: postgres=# SELECT pg_postmaster_start_time();      ...