Our Tech Ideas | Great minds discuss ideas!
Introduction Database backups are crucial for ensuring data integrity and disaster recovery. As a database administrator or developer, having reliable scripts to monitor and manage backups is essential. In this…
Read FullBacking up your vital data is critical, but mistakes do happen. It is critical to understand the potential causes of Database Backup Failure and how to resolve them. In this…
Read FullOnce upon a time, there was a innocent Database Administrator (DBA) who had to restore a database but leave out certain tables. However, he didn't know how to do it.…
Read FullWe can take a COPY_ONLY backup of a TDE protected (encryption enabled) database on Azure SQL Managed Instance using the following steps. 1. Connect to your Azure SQL Managed Instance…
Read FullIntroduction In Microsoft SQL Server, backup compression is a powerful feature that can significantly reduce the size of database backups, thereby saving storage space and improving backup and restore performance.…
Read FullAs a DBA you may face a few common questions whenever someone accidentally deleted some database objects or the whole database. “How long-time SQL Server will take to complete the…
Read FullBackup and restore all databases from an old SQL server and restore it on new SQL server. The number of databases are approx 99+. Let's try to make backup and…
Read FullIntroduction Here we will discuss different backup strategies and methodologies used to take the table backup in SQL Server with real-life examples. There are different methods of taking backup in…
Read FullIntroduction Backing up a database is one of the most important things you need to do when having a database depended application. It's only all of your data in there,…
Read FullIntroduction This script will help you to get the restore history for all the databases. If you need to know the restore history only for a single database then please…
Read Full
