SQL Server Filegroup Backup and Restoration

In this video, I show how to back up and restore SQL Server databases in piecemeal form, using filegroups to manage read-only versus read-write data, and bringing the most important data back online sooner in a recovery scenario. LINKS AND INFO Catallaxy Services - https://www.catallaxyservices.com BACKUP (Transact-SQL) - https://learn.microsoft.com/sql/t-sql... Database files and filegroups - https://learn.microsoft.com/sql/relat... Back Up Files and Filegroups - https://learn.microsoft.com/sql/relat... Restore Files and Filegroups - https://learn.microsoft.com/sql/relat... Determining Filegroup for a Table - https://www.sqlservercentral.com/blog... Backup and restore SQL Server database filegroup - https://stackoverflow.com/questions/2... Piecemeal Restore of Databases with Memory-Optimized Tables - https://learn.microsoft.com/sql/relat...