Don’t Use AWS AMI To Backup Your EC2 Database Server

Don't Use AWS AMI To Backup Your EC2 Database Server

I have started my career to handle the databases which all are in the Cloud. Most of the database servers are in AWS EC2. AMI is one the simplest and great feature to take a VM level backup and restore it when a disaster happens. But DBAs never depend on the VM or SAN backups, so I have configured native backups for all of my database servers. But I used to choose to restore the AMI whenever we need a Dev/Test server. Because restoring a huge database will take more time and its pretty expensive operation. So I just drop the existing Dev DB server and launch it from the AMI.

Read More

How To Restore Corrupted System Databases

How To Restore Corrupted System Databases

Today Dec 31, Sunday. Everybody waiting for the New Year. I’m¬†also waiting for that and enjoying the last holiday of this year. But my SQL server doesn’t like the 2018 I guess ūüôĀ We have migrated¬†our SQL Datawarehouse from Datacenter to AWS. We followed block level copying method which means sent entire Disks data to AWS then create volumes from that data. We kept data and logs on different disks.

Read More

SQLServer Backup with dbatools vs Olahallengren

SQLServer Backup with dbatools vs Olahallengren

dbatools vs Olahallengren

Short Story: The dbatools is growing too fast, so many Powershell modules are there. I just compared the backup module with Ola Hallengren’s backup script.

Who all are working as a SQL Server DBA, we must be scheduled the backup job in SQL Agent with our own TSQL scripts. But most of the DBAs are recommended to use Ola hallengren‚Äôs backup script. Because it gives us a reliable backup and easy to locate the backup files. I’m also a fan of Ola‚Äôs script. Im using this in my all production servers.

Read More