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.
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.