Excellent article.

It gave me new trick.

After testing with new File Group and File at principal, mirroring works.

But, I cannot create database snapshot at mirror.

Before adding File, the following one worked.

CREATE DATABASE Mirror_Test_snapshot ON

( NAME = N'Mirror_Test_Data',

FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Mirror_Test_Data_snapshot.snap')

AS SNAPSHOT OF Mirror_Test;

After adding File at Node1\Mirror_Test_FG_IDX_1.Mirror_Test_FG_IDX_1.ndf at principal

Restoring at Node2\Mirror_Test_FG_IDX_1.ndf at mirror

, this one doesn't work.

CREATE DATABASE Mirror_Test_snapshot ON

( NAME = N'Mirror_Test_Data',

FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Mirror_Test_Data_snapshot.snap'),

(NAME = N'Mirror_Test_FG_IDX_1',

FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Node2\Mirror_Test_FG_IDX_1_snapshot.snap')

AS SNAPSHOT OF Mirror_Test;