[SQL2000] Transactional replication and database filegroups

Hello everybory
Some general question about Transactionnal Replication features on SQL 2000
In case of using Trans. Repl. to duplicate a whole database to another SQL
2000 server, does the Transactionnal Replication preserve database's
filegroup (i.e. tables/indexes distributed accross different files on disk ) ?
No info found about it in the BOL or KB.
I have made some testings and even when the destination database is created
with multiple filegroups before transactionnal replicatiion activated, all
the tables fall in the PRIMARY filegroupn whatever their initial filegroup in
the source database.
Any option or hints to do this ?
Thank in advance
Jb,
you could script out the creation of filegroups and creation of objects onto
particular filegroups. On the publication properties, this script could be
made to run before the snapshot is applied. On the article properties,
naming conflicts section, you can select to leave the table intact if it
already exists. This bypasses the inbuilt snapshot schema generation.
HTH,
Paul Ibison
"Jb Vernejoux" <JbVernejoux@.discussions.microsoft.com> wrote in message
news:AB06D8F0-1CB8-4E44-AC66-FEBC5311CD8C@.microsoft.com...
> Hello everybory
> Some general question about Transactionnal Replication features on SQL
2000
> In case of using Trans. Repl. to duplicate a whole database to another SQL
> 2000 server, does the Transactionnal Replication preserve database's
> filegroup (i.e. tables/indexes distributed accross different files on
disk ) ?
> No info found about it in the BOL or KB.
> I have made some testings and even when the destination database is
created
> with multiple filegroups before transactionnal replicatiion activated, all
> the tables fall in the PRIMARY filegroupn whatever their initial filegroup
in
> the source database.
> Any option or hints to do this ?
> Thank in advance
|||use a pre snapshot command that adds the file groups. (Alter database test
add filegroup file_group).
and then add some files to this filegroup
ALTER DATABASE test
ADD FILE(NAME = 'test_FG', FILENAME = 'C:\temp\test_FG_Data.NDF', SIZE = 1,
FILEGROWTH = 10%) TO FILEGROUP [test]
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uuKyWTciEHA.2664@.TK2MSFTNGP11.phx.gbl...
> Jb,
> you could script out the creation of filegroups and creation of objects
onto[vbcol=seagreen]
> particular filegroups. On the publication properties, this script could be
> made to run before the snapshot is applied. On the article properties,
> naming conflicts section, you can select to leave the table intact if it
> already exists. This bypasses the inbuilt snapshot schema generation.
> HTH,
> Paul Ibison
> "Jb Vernejoux" <JbVernejoux@.discussions.microsoft.com> wrote in message
> news:AB06D8F0-1CB8-4E44-AC66-FEBC5311CD8C@.microsoft.com...
> 2000
SQL[vbcol=seagreen]
> disk ) ?
> created
all[vbcol=seagreen]
filegroup
> in
>
|||ok,
thanks all for your info
Jb VERNEJOUX
"Hilary Cotter" wrote:

> use a pre snapshot command that adds the file groups. (Alter database test
> add filegroup file_group).
> and then add some files to this filegroup
> ALTER DATABASE test
> ADD FILE(NAME = 'test_FG', FILENAME = 'C:\temp\test_FG_Data.NDF', SIZE = 1,
> FILEGROWTH = 10%) TO FILEGROUP [test]
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:uuKyWTciEHA.2664@.TK2MSFTNGP11.phx.gbl...
> onto
> SQL
> all
> filegroup
>
>