To attach an In-Memory database with T-SQL, use CREATE DATABASE with FOR ATTACH and list the data file, the log file and, when it moved, the container folder. This post builds a demo database, detaches it and attaches it twice. It also shows which rows survive.
SQL SERVER – Attach a Database with T-SQL
To attach a Database with T-SQL, I use CREATE DATABASE … FOR ATTACH. A customer asked about attaching existing data and log files.
Long-Term Backup Retention in Azure SQL Database
Configure long-term backup retention in Azure SQL Database, inspect retained recovery points, restore a separate copy, and review costs.
SQL SERVER – Simple Recovery Model and Restrictions
Simple Recovery changes recovery options before it changes a performance diagnosis. I choose it from the agreed recovery requirements.
SQL SERVER – Running Log Backup While Taking Full Backup
A full backup and log backup can overlap on one SQL Server database. A customer noticed both during a slowdown.
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.