Mirroring or Replication question! 2

[Antzz]

Hi Guys,
Either with mirroring or replication, is it possible to have different file structures in the primary and secondary servers? By this I mean, there might be 2 filegroups in the first server with tables allocated amongst those groups and possibly 4 filegroups in the secondary server with the distribution of tables being different.

Thanks a lot.

 

[Crowley16]

with replication you definitely can, with mirroring, I think you can as well, but I've not done it myself yet...

--------------------
Procrastinate Now!

 

[mrdenny]

With replication, yes. With Mirroring no. The number of files needs to be the same. About all you can change is the location of those files.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[Antzz]

Thanks guys!