tuntun.oo (3/3/2011)

---

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;