From the course: SQL Server 2016: Administer a Database Infrastructure

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Restore file groups

Restore file groups - SQL Server Tutorial

From the course: SQL Server 2016: Administer a Database Infrastructure

Start my 1-month free trial

Restore file groups

- [Instructor] If you're leveraging file groups to segment out your data, especially when following best practices and storing them on different drives, then it's possible that a single file group's data file may become corrupted or otherwise go offline. When this happens, there's no need to perform a full database restore. After all, the rest of the file groups are all still safe and sound. By only restoring the file groups that need it, you can speed up the restoration process. Now this example is going to take a few steps to get set up. Let's go ahead and start by creating a new database called FGRestoreDB. Then, I want to make sure I'm using the full recovery model, so I'll alter the database and set its recovery mode to full. Next, we need this database to have an additional file group. So I'll alter the database, FGRestoreDB, and we'll add a file group called ColdStorageFG. Now that the file group is created, we need to create a file on disk where we can store the data for this…

Contents