Automate SQL server backup file removal/deletion from Azure blob storage

In this post, we would like to explain one of the interesting issues that we encountered while working with azure backups and restore. Symptoms Cannot delete the .bak files from azure blob storage through maintenance plans or any other options from SQL which have been backed up using backup to URL or managed backup Cause…

1

SQL server 2008 Filestream

Filestream is a  new feature in SQL server 2008, that allows storage and efficient access to BLOB data, using combination of SQL Server 2008 and NTFS file system. It provides  an easy way of handling BLOB data with database transactional consistency, integrated management, security and excellent streaming performance. It basically maintains transactional consistency between the…

2