sql restore

SQL SERVER – Check Backup Reliability

Recently I was asked by one of my clients of Comprehensive Database Performance Health Check recently asked if there is any way to Check Backup Reliability. Well, honestly, yes there is a way and that is to restore the...

SQL SERVER – Attach an In-Memory Database with T-SQL

Earlier I wrote a blog post about SQL SERVER – Attach a Database with T-SQL. Right after reading this blog post, my client of Comprehensive Database Performance Health Check sent me an email asking if there is any...

SQL SERVER – Attach a Database with T-SQL

Yesterday one of my clients of Comprehensive Database Performance Health Check reached out to me asking for help in attaching the database files to the server. Let us see today we can attach a database with...

SQL SERVER – Simple Recovery Model and Restrictions

Most of the time during the Comprehensive Database Performance Health Check, I focus on SQL Server Performance Tuning. However, often the client also asks for help when they have a question about SQL Server Engine....

SQL SERVER – Running Log Backup While Taking Full Backup

Recently, I got a very interesting question from my client of the Comprehensive Database Performance Health Check. As many of you know that I primarily focus on the SQL Server Performance issue. If your server is...

Undo Human Errors in SQL Server – SQL in Sixty Seconds #109 – Point in Time Restore

In this blog post, we are going to talk about how to undo human errors in SQL Server with the help of Point in Time Recovery. Let me start asking some questions –Have you ever dropped your table by mistake?Have you...

What does Verify Backup When Finished do in SQL Server? – Interview Question of the Week #283

Question: What does Verify Backup When Finished do in SQL Server?Answer: It will check up if the backup media is in the place and also checked the header information to make sure that it looks like the header of the...

SQL SERVER – Restore Database With Just Log File

Restoring the database with Just Log File is not possible. If you are looking for the answer to this question, you have bad news. I am writing this blog post for a simple reason, when I get an email asking for the same...

How to Know Backup Speed in SQL Server? – Interview Question of the Week #277

Question: How to Know Backup Speed in SQL Server?Answer: It is very simple to know the backup speed in SQL Server.You can get the answer to this question with the help of SQL Server Management Studio. Let us run the...

$SQL SERVER – Msg 3254 – The Volume on Device Path\File is Empty. RESTORE DATABASE is Terminating Abnormally$

SQL SERVER – Msg 3254 – The Volume on Device Path\File is Empty. RESTORE DATABASE is Terminating Abnormally

During the recent consulting engagement Comprehensive Database Performance Health Check with SQL Server 2017/2019, my client’s DBA asked me if I can help with an error message which they are seeing while restoring a...

How to Forecast the Size of Restore of Backup in SQL Server? – Interview Question of the Week #265

Question: How to Forecast the Size of Restore of Backup in SQL Server?Answer: Recently, I had discussed this in consulting engagement: Comprehensive Database Performance Health Check. We had a very unique scenario where...

SQL SERVER – SQL Azure Managed Instance Restore Error – The Database Was Backed Up on a Server Running Version 15.00.2000

Based on the current trend of moving to the cloud platform, there have been many new learnings for me. One of my clients migrated to SQL Azure Managed Instance and contacted me for an interesting situation. In this...

SQL SERVER – Add Database to Availability Group Failure – This BACKUP or RESTORE Command is Not Supported on a Database Mirror or Secondary Replica

I always recommend my client to go with the latest and great version of tools like SQL Server Management Studio (SSMS). In this blog, we would learn about a situation where an older version of SSMS was giving an error...

SQL SERVER – Drop failed for Availability Group – Failed to Destroy the Windows Server Failover Clustering Group Corresponding to Availability Group

While working with one of the clients to recover from a disaster, I encountered an error. In this blog we would talk about error Drop failed for Availability Group. If you want any such assistance, you can hire me for...

SQL SERVER – Cluster Install Failure – Code 0x84cf0003 – Updating Permission Setting for Folder Failed

There are various issues which I have seen SQL installation and most of the time they are intuitive. The error message is mostly helpful and provides the right direction. In this blog we would discuss error Updating...

SQL SERVER – Small Backup for Large Database

Recently, I had a very interesting experience with one of my customer while working with them on Comprehensive Database Performance Health Check. The issue was related to small backup for the large database and it was...

SQL SERVER – Restoring SQL Server 2017 to SQL Server 2005 Using Generate Scripts

Let me answer the first question first – There is no way to backup and restore SQL Server 2017 to SQL Server 2005 with the help of any tools. In this blog post, we will learn about how we can generate scripts to...

SQL SERVER – Monitor Estimated Completion Times for Backup, Restore and DBCC Commands

Earlier this week, we were fortunate to receive an amazing script to overview HADR / AlwaysOn Local Replicate server from SQL Server Expert Dominic Wirth. You can read the amazing script here: Scripts to Overview HADR...

SQL SERVER – Msg 3292: A Failure Occurred While Attempting to Execute Backup or Restore With a URL Device Specified

In my recent project with a customer, they wanted to configure SQL backups to Azure Blob Storage. When we were trying to take a backup, we were facing error. In this blog we would learn how to fix error message 3292 –...

SQL SERVER – Backup to Microsoft Azure Tool – ERROR: Account Verification Failed

I have been seeing many customers moving their SQL Server to Cloud. Few of them have chosen Microsoft Azure platform to host their production server and few others have selected other cloud platforms like AWS. When they...

SQL SERVER – Restore Database Wizard in SSMS is Very Slow to Open

Recently I was hired for my On Demand (55 minutes) Service by an organization and they had a very interesting situation. To be very honest, I was initially lost for few moments when they described this situation to me...

SQL SERVER – AlwaysOn Automatic Seeding Failure – Failure_code 15 and Failure_message: VDI Client Failed

Recently I wrote a blog explaining a situation where taking log backup can break automatic seeding and synchronization would not work. Below is the blog reference. SQL SERVER – AlwaysOn Automatic Seeding – Database...

SQL SERVER – AlwaysOn Automatic Seeding – Database Stuck in Restoring State

As a part of my consulting, I observed that there is a lot of interest in using AlwaysOn availability group. I have deployed many AlwaysOn solutions from start-to-finish. Recently I encountered an issue and in this...

SQL SERVER – FIX: Msg 3009 – Could Not Insert a Backup or Restore History Detail Record in the MSDB Database

While preparing for a demo session for my client, I was playing with SQL Server backups on my lab server. I encountered an error which I am going to blog here. Here is the error about backup or restore history...

SQL SERVER – Fix Error – Restore Operation Failed for Database Due to Insufficient Memory in the Resource Pool ‘Default’

Recently I faced a strange error related to SQL Server, during Comprehensive Database Performance Health Check. The error indeed surprised me because as I have been doing performance tuning consulting for over 10...