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

Using Bulk Logged recovery model for Bulk Operations will reduce the size of Transaction log backups – Myths and Truths

It’s has been couple of years for me working on SQL Server and I keep coming across various SQL Server misconceptions (or say a DBA Myth). In this specific post I’ll demystify a common DBA myth around log-shipping: "In a log shipping setup, to have smaller size T-log log backups being shipped to secondary, switch…

18

SQL Server Backup Simulator

We at SQL Server support team, continue to invest our time in writing tools and utilities which can aid you in troubleshooting SQL Server issues. SQL Server Backup Simulator is one such tool which will help you while troubleshooting issues in taking backup of SQL Server using 3rd party utilities like IBM Tivoli, Symantec BackupExec,…


TRANSACTION LOG BACKUP and RESTORE SEQUENCE: Myths & Truths

In a recent issue with a customer, I came across a strange SQL belief (or say a DBA Myth) regarding SQL Server Transaction Logs Backup/Restore. Let me explain you what was the scenario and then let’s try attempting to break the myth with quick testing.   SCENERIO: –    Customer is taking FULL and TRANSACTION LOG…


How to restore database backup (Full and Transaction logs) after regenerating Database Encryption Key (KEY) with a new certificate having no impact on Log sequence number (LSN) chain.

It’s a very common scenario where customers have their database encrypted and hold multiple certificates on their SQL Server environment. In this blog I would be sharing some good information on steps to restore full backup that was taken at the time when the database was not encrypted and applying the Transaction logs backups which was…


Not able to restore backup from tape for large databases on the SQL Server 2005

We get the below error message when we try to restore from tape for large databases.   ERROR MESSAGE: ============== TITLE: Microsoft SQL Server Management Studio —————————— An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) —————————— ADDITIONAL INFORMATION: Timeout expired. The timeout period elapsed prior to completion of the operation or the…

4

How to backup SQL Server databases to a mapped drive

While taking backups for SQL Server databases onto a mapped drive you might get the following error: “The system cannot find the path specified.” This is because a network share that you map using a local drive letter will not be visible to a SQL Server instance as it is running as a service. So,…


Maintenance Plans with “Backup Database Task” fails when the “Create a sub-directory for each database” option is checked

Maintenance Plans with “Backup Database Task” fails when the “Create a sub-directory for each database” option is checked, with error similar to the below, “Cannot open backup device ‘D…  The package execution fa…  The step failed.,00:00:01,0,0,,,,0”   Detailed Error Message================== Executed as user: MachineName\SYSTEM. …9.00.3042.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.   …

9

Regeneration of the Master Key fails when we try to take the backup of the Original Database and Restore on other instance of SQL server on other Machine

We have a production database in which the data is encrypted. The encryption follows the following hierarchy   1) The data is encrypted using Symmetric key 2) The symmetric key was encrypted using asymmetric key 3) The asymmetric key was encrypted using the master key of the database 4) The master key of the database…

3