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.
SQL SERVER – Attach an In-Memory Database with T-SQL
My client of Health Check sent me an email asking if there is any other method when we have to attach an In-Memory Database with T-SQL.
SQL SERVER – Attach a Database with T-SQL
One of my clients 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 T-SQL.
SQL SERVER – Simple Recovery Model and Restrictions
I received a question from a client that they want to move their database from the Full Recovery Model to the Simple Recovery Model, can they do it?
SQL SERVER – Running Log Backup While Taking Full Backup
They found out that they have a full backup running for one of the largest servers and at the same time they are running a log backup on the same server.
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 us learn today.
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? It looks like a very important step in the entire backup and restores.