|
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?
(comments are locked)
|
|
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.
(comments are locked)
|
|
Yes, it is, but you can't mirror FILESTREAM filegroups under 2008.
(comments are locked)
|
|
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, ...)
(comments are locked)
|
|
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.
(comments are locked)
|
