Question: What does Verify Backup When Finished do in SQL Server? It looks like a very important step in the entire backup and restores.
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. It is not possible.
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. Let us discuss today.
SQL SERVER – Impact of Recovery Model on Insert Workload Stress Test and Wait Statistics
Today we will talk about the Tecovery Model on Insert Workload Stress Test and Wait Statistics. I had earlier consulted for during Health Check.
SQL SERVER – What do These Messages Mean – “I/O is Frozen on Database” and “I/O was Resumed on Database”?
“I/O is frozen on database” and “I/O was resumed on database”? Did you check the air conditioner temperature? Let us learn about it in today’s blog post.
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:
SQL SERVER – Error 35296: Log Backup for Database “SQLAuthority” on Secondary Replica Failed Because the New Backup Information Could Not be Committed on Primary Database
Log backup for database “SQLAuthority” on secondary replica failed because the new backup information could not be committed on the primary database.