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.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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.
This is not a supported feature of SQL Server 2008 R1 Enterprise.
Though, not officially from Microsoft, concurrent backups of anything but the transaction log cause other backups running on the same database to block. Source: http://blogs.msdn.com/b/arvindsh/archive/2008/12/30/concurrency-of-full-differential-and-log-backups-on-the-same-database.aspx