SQL Backup Archives - Page 13 of 19 - SQL Authority with Pinal Dave

SQL SERVER – Msg 3101, Level 16 – Exclusive Access Could not be Obtained Because the Database is in Use

April 4, 2017

This error might have seen by DBAs and they know how to fix it. This blog goes in little details about what are the various options available. Here is the simple reproduction of the error message related to exclusive access.

How to Get Status of Running Backup and Restore in SQL Server? – Interview Question of the Week #113

March 12, 2017

Pinal Dave

SQL Interview Questions and Answers

SQL Backup, SQL Restore, SQL Scripts, SQL Server

QHow to Get Status of Running Backup and Restore in SQL Server?

SQL SERVER – FIX : Msg 35295, Level 16 – Log Backup For Database ‘DBName’ on a Secondary Replica Failed

March 9, 2017

Pinal Dave

SQL

AlwaysOn, SQL Backup, SQL Log, SQL Mirroring, SQL Server

Once, while doing a load testing with my client, I was shown below error while taking log backups on secondary replica.

Msg 35295, Level 16, State 1, Line 1
Log backup for database “MyAppDB” on a secondary replica failed because the last backup LSN (0x0016ff11:00032258:0001) from the primary database is greater than the current local redo LSN (0x0016ffec:0006ee28:0001). No log records need to be backed up at this time. Retry the log-backup operation later.
Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.

SQL SERVER – Cannot open backup device. Operating system error 1326 (Logon failure: unknown user name or bad password.)

February 18, 2017

Pinal Dave

SQL

SQL Backup, SQL Error Messages, SQL Restore, SQL Scripts, SQL Server

There might be various reasons for above error, but this case is very specific to a situation where SQL Server was installed on a machine which was in Workgroup whereas the backup destination was the server located in the domain. Here is the error message seen in SQL Agent job history. Let us learn about how to fix Operating system error 1326.

SQL SERVER – Powershell Script – Remove Old SQL Database Backup Files from Azure Storage

February 17, 2017

Pinal Dave

SQL Tips and Tricks

Powershell, SQL Azure, SQL Backup, SQL DateTime, SQL Scripts, SQL Server

Few days back I wrote blog to help my blog reader and this is follow up on the same post How to Add Date to Database Backup Filename? – Interview Question of the Week #109. In this blog post we will see a powershell script for Removing Old SQL Database Backup Files from Azure Storage.