Is it possible to implement Database Mirroring in SQL Server 2005 (any mode) if the database being mirrored has multiple filegroups, i.e. one of more .ndf files?
asked
Database Mirroring with multiple filegroups
Also, be aware when adding a new file to a mirrored database that the underlying directory structure has to already exist on the mirror server or adding the new file will fail on the mirror.
Yes, it is, but you can't mirror FILESTREAM filegroups under 2008.
When you restore the initial backup, you specify the filegroup structure, and can have the filegroups in different locations, however as mentioned by Matt, the FILESTREAM filegroup is not supported.
Yes you can ;)
Best is to have the same logical disk names and directory structures underneath your databases. (that guarantees that you can add files to filegroups, ...)
