Monitoring Backups Across Instances
Introduction In the last two or three months, I have been asked twice for a solution native to SQL...
Backup and Restore FILESTREAM-Enabled Database
In my previous articles, I explained how to create and configure the FILESTREAM feature in SQL server instance. Moreover, I demonstrated...
Fixing Data Loss Using Log Shipping with Delayed Recovery
Introduction Transaction Log Shipping is a very well-known technology used in SQL Server to maintain a copy of the live database in the...
Configuring Azure SQL Long-term Backup Retention
Backup is the most important case for database administration because it provides business...
Scheduled Maintenance of the 24/7 IS Database in MS SQL Server
Introduction This article is a short review of the main scheduled maintenance with a database of the 24/7 information system that does not...
