I have 62 readonly filegroups in a SQL server 2008 enterprise database. Can I backup multiple read only filegroups at the same time? I would assume this to be the case but given this database is over 20TB in size I do not want to invalidate any files by giving it the ol' college try.
Sql-server – run concurrent backups of multiple read only filegroups
backupfilegroupssql server
Related Question
- Sql-server – Benefit of filegroups and setting filegroups to read-only
- Sql-server – SQL Server – What backup/restore strategy should I use to accomplish the following
- Sql-server – Multiple filegroups vs. multiple files in a single filegroup
- Sql-server – Restore Read Only FileGroups from File
- Sql-server – Restore a single database backup (.bak) file into multiple filegroups
- Sql-server – Initial Full Backup required for Filegroup Backups
Best Answer
Yes you can do multiple full file-group backups concurrently. The primary concern I would have would be for disk I/O and network I/O throughput doing so many at once. They'll still complete, just all slowly. Unless you have the I/O to handle 20TB at once.