Tag: Backup and Restore
This tag groups together all the articles and posts related to SQL Server backup and restore operations
-
dutyDBA Case Files #2 – Who dropped the tables and deleted/recreated stored procedures on the production database?
In this edition of dutyDBA case files, I show you how to investigate an unauthorised production database change to figure out who made the changes. This walks you through the process of recovering from the application outage, and identifying the root cause.
-
dutyDBA Case Files #1 – Unable to change the database owner on secondary replicas to sa
This case notes is from a real world incident, where a DBA account could not be dropped because it owns the databases on an Always On secondary replica. I investigate how it happened and show you how to resolve it, and prevent it from happening again.
-
How to check the last backup date of every database on your SQL Server?
This article provides a script to display the last backup date of all the database on your SQL Server. This covers the three main types of backups (full backup, transaction log backup and differential backup)
-
How to monitor all the currently running SQL Server Backup and Restore operations in real time?
Imagine a scenario: You have a very busy non-production environment hosting dozens of databases. Lots of developers are actively using the server. They are backing
-
How to find the last restore date (when, from where, and to what point) of every SQL Server Database on your server?
Some non-production environments require copies of latest production databases for live testing, bug fixing and new code deployments. These environments have a current production database
Latest Articles
