Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Previously i just shared the full backup script. Now we will take incremental backups using last_checkpoints. Basically, what this script will do is that …
Read More »
Tag Archives: Backup
Restore a Sharded Cluster with Database Dumps in MongoDB
Before restoring database dumps to new servers we need to install MongoDB on each system. Step 1: Installation: [crayon-68eb6bb8b9660827956415/] inside it: [crayon-68eb6bb8b9665865131526/] [crayon-68eb6bb8b9667232460761/] …
Read More »Automatizing backup process on sharded clusters
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 …
Read More »Back Up a Sharded Cluster with File System Snapshots
In MongoDB we can take backups with database dumps or filesystem snapshots. In large databases it is recommended to use file system snapshots rather …
Read More »How To Change The Disk Of Database Files On SQL Server(Detach Attach & Backup Restore Methods)
In some cases, there may not be enough space on the disks where the database files are located. For this reason, you may need …
Read More » Database Recovery Mode in SQL Server
This article contains information about database recovery mode in SQL Server. You will find many information about FULL,SIMPLE and BULK LOGGED Recovery models and differences …
Read More »