SQL Server Basics #4 – Restore Options
There are a few reasons that one might need to restore a SQL Server backup. Perhaps it is time to refresh a test database with a copy from production. Maybe there has been a disaster and this is how the disaster recovery plan is getting the system back online. Another common restore reason is to recover a single data element that was removed or modified in production by accident. Whatever the reason, being able to restore a database and understanding some of the basic options thereof is an essential skill for the SQL Server DBA. For this demo I will cover the topic using theRead More →