Join Martin Guidry for an in-depth discussion in this video Restoring filegroups separately, part of SQL Server 2012: Designing Database Solutions.
- In some of the previous sections…I talked about when we do a restore…from a backup we have the option…to restore some of the file groups…and not all of the file groups.…You always have to restore the primary file group…but any secondary user defined file groups…are optional when doing the restore.…One of the reasons you might wanna do this…would be if you had some high priority data…and some low priority data.…When you do the restore you could get all…of the high priority information online immediately…and then wait and at some point later…worry about the low priority data.…
So, I'm gonna demonstrate to you now…how to do this.…I've staged some code for you.…If you wanna copy the top part of this…over to a new query.…First, what we're going to do on lines 1 and 2…is set AdventureWorks into the full recovery mode.…In order to do a Piecemeal restore…we are required to be in full recovery mode…and then lines 6, 7, and 8…are just going to do a basic backup,…mostly with the default options.…I did change the path rather than use the default path.…
- Planning the database infrastructure
- Designing databases vs. data warehouses
- Designing the physical database implementation
- Planning for partitioning
- Adding FileStream data
- Monitoring server health
- Managing SQL Server with PowerShell
Skill Level Intermediate
1. Designing a Database Server Infrastructure
2. Designing a Logical Database Schema
3. Designing a Physical Database Implementation
4. Incorporating Data Files into Databases
5. Tuning Database Performance
6. Policy-Based Management
7. Monitoring Server Health
Exploring health data5m 3s
8. Managing SQL Server with PowerShell
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.