Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

  Before restoring database dumps to new servers we need to install MongoDB on each system. Step 1: Installation: [crayon-684b49e253d01750196358/]   inside it: [crayon-684b49e253d07490105655/] [crayon-684b49e253d09925930136/] …

  In sharded replicas before backup process you need to disable balancer and when backup finishes you need to enable the balancer. This process doesn’t …

  In MongoDB we can take backups with database dumps or filesystem snapshots. In large databases it is recommended to use file system snapshots rather …

  You can login to a remote Linux server without entering password in 3 simple steps using ssky-keygen and ssh-copy-id as explained in this article. …

This article contains information about mysql safe mode such as start mysql in safe mode, find mysqld_safe location, changing password. MySQL Safe Mode Sometime you …

  1.Check error log to find the tempdb full. 2.Find out the space free in tempdb using [crayon-684b49e259946236402372/] 3.dum tran with truncate only if still …

  In this article I will explain some information about SQL Server System databases. System databases are created automatically when you install SQL Server. The …

  What is Teradata: Teradata is a relational database management system (RDBMS) that is: an open system, running on a UNIX MP-RAS or Windows server platform. capable of …

  The prevalent influence of technology has resulted in a widespread use of a variety of devices such as cell phones, sensors, web API’s and …

Replication lag Typically, in our replica sets, we monitoring the replication lag, that is a measure of who far a secondary is behind the primary: …