Question: What does Keyword STATS Indicates in Backup Scripts in SQL Server?
SQL SERVER – Msg 1833 – File Cannot be Reused Until After the Next BACKUP LOG Operation
While preparing for a demo for an upcoming session, I came across an error which I didn’t see earlier. Here is the error in the UI and it is related to Backup Log Operation.
What does BACKUP WITH NAME Command do? – Interview Question of the Week #130
Questions: What does BACKUP WITH NAME Command do?
SQL SERVER – Alternative of Log Shipping in Simple Recovery Model
The blog topic might seem controversial and doesn’t go well with definition of log shipping features. Read it again. The blog has an alternative way to set up something “similar” to log-shipping. If the database is in simple recovery model, then we can’t take transaction log backups and hence no log shipping possible.
What is Copy Only Backup in SQL Server? – Interview Question of the Week #128
Question: What is Copy Only Backup in SQL Server?
Answer: This is another interesting question I received the other day. The question was in the image form and I am re-producing the image again here.
SQL SERVER – Msg 3168, Level 16 – The Backup of the System Database on the Device Cannot be Restored Because it was Created by a Different Version of the Server
In the recent past, I have written a blog about Ransomware. Here is the link. system database – How to Protect Your Database from Ransomware?
SQL SERVER – Unable to Restore from URL – The Specified URL Points to a Block Blob. Backup and Restore Operations on Block Blobs are not Permitted
With Microsoft Azure pitching in the market, I am getting few clients who want me to assist them for errors related to Azure as well. As a part of growth, I do learn them and try to help the clients. Let us learn about Block Blobs in this blog post.