Re: Pushing Blob content through Replication
From: Geoff N.Hiten (SRDBA_at_Careerbuilder.com)
Date: 02/09/04
- Next message: Rainer: "RE: The process could not create file / because it is being used by another process"
- Previous message: Paul Ibison: "RE: Pushing Blob content through Replication"
- In reply to: TJ: "Pushing Blob content through Replication"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 9 Feb 2004 10:47:41 -0500
There is a max text repl option that may need adjusting upwards if you push
large BLOBS using replication. I would also consider using a dedicated
distribution machine to remove the workload of handling all the
subscriptions from your primary server.
-- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator Careerbuilder.com I support the Professional Association for SQL Server www.sqlpass.org "TJ" <anonymous@discussions.microsoft.com> wrote in message news:E77E160C-8829-496D-995D-F3EC3F8E5D51@microsoft.com... > Hello, > > We are planning to store documents in SQL 2000 as BLOBs and then push this content to other > geographical locations around the world. We just need to create snapshots and replicate them > to other SQL 2000 servers. > > Does anyone have any experience about what performance implications are there ? Is there > any other better alternative to publishing this content to other servers ? ( like using DTS, > FTP etc ?) > > Appreciate any insights > > Thanks !
- Next message: Rainer: "RE: The process could not create file / because it is being used by another process"
- Previous message: Paul Ibison: "RE: Pushing Blob content through Replication"
- In reply to: TJ: "Pushing Blob content through Replication"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
