Database Replication

We currently have multiple tables being replicated using merge snapshot. In
the majority of cases the whole table is required or a row filter is applied
based on a value in that table.
We have two sets of identical databases, except for their data, that
replicate their data from a backend database towards a frontend database.
The problem is that for database 1, all the necesarry data is replicated,
but for the other database 2, which has the same parameters, replication
settings etc.. certain blob files containing pdf files will not replicate
from the backend database towards the frontend database.
The replication only replicates the .doc files, so the replication is
partially done for the table that contains the .doc and .pdf files.
When I run the initial snapshot, the pdf files are replicated fine, but when
the agent runs, the pdf files are not replicated.
Has anyone encountered similar problems? Can someone identify what is
causing the problem by explaining why this is not working? My first idea
would be the sheduling the snapshot to run every night, instead of the
agent, but this would be a far from ideal solution and one that I would only
consider as a last choice. I fail to understand why the replication works
for database 1, but not for database 2.
parnold8104@.hotmail.com
can you run this command sp_configure 'max text repl size'
and then figure out what your maximum data size in the blob columns you are
replicating?
"Peter A" <parnold8104@.hotmail.com> wrote in message
news:%23sFpoRuJEHA.2456@.TK2MSFTNGP12.phx.gbl...
> We currently have multiple tables being replicated using merge snapshot.
In
> the majority of cases the whole table is required or a row filter is
applied
> based on a value in that table.
> We have two sets of identical databases, except for their data, that
> replicate their data from a backend database towards a frontend database.
> The problem is that for database 1, all the necesarry data is replicated,
> but for the other database 2, which has the same parameters, replication
> settings etc.. certain blob files containing pdf files will not replicate
> from the backend database towards the frontend database.
> The replication only replicates the .doc files, so the replication is
> partially done for the table that contains the .doc and .pdf files.
> When I run the initial snapshot, the pdf files are replicated fine, but
when
> the agent runs, the pdf files are not replicated.
> Has anyone encountered similar problems? Can someone identify what is
> causing the problem by explaining why this is not working? My first idea
> would be the sheduling the snapshot to run every night, instead of the
> agent, but this would be a far from ideal solution and one that I would
only
> consider as a last choice. I fail to understand why the replication works
> for database 1, but not for database 2.
> parnold8104@.hotmail.com
>
>
|||Hi Hilary,
thanks for replying, when I run the command sp_configure I get these values:
max text repl size (B) minimum: 0
maximum: 2147483647
config_value: 52428800
run_value: 52428800
I am not sure if the data size is the problem, because the .doc files that
are replicated are larger in size then the pdf files. Another thing I
noticed is that I can replicate my pdf records in the 'faulty' database, but
only if I do an update of the record in my backend database. So when the
record is 'new' the replication skips it, but if I update the record, by for
example changing a letter in a description field, the replication picks up
the record and pushes it towards the frontend database.
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:eJKebhuJEHA.3592@.TK2MSFTNGP09.phx.gbl...
> can you run this command sp_configure 'max text repl size'
> and then figure out what your maximum data size in the blob columns you
are[vbcol=seagreen]
> replicating?
> "Peter A" <parnold8104@.hotmail.com> wrote in message
> news:%23sFpoRuJEHA.2456@.TK2MSFTNGP12.phx.gbl...
> In
> applied
database.[vbcol=seagreen]
replicated,[vbcol=seagreen]
replicate[vbcol=seagreen]
> when
> only
works
>
|||can you post your schema and publication scripts here?
What version of SQL are you using? SP?
"Peter A" <parnold8104@.hotmail.com> wrote in message
news:%23whCdr3JEHA.232@.TK2MSFTNGP12.phx.gbl...
> Hi Hilary,
> thanks for replying, when I run the command sp_configure I get these
values:
> max text repl size (B) minimum: 0
> maximum: 2147483647
> config_value: 52428800
> run_value: 52428800
> I am not sure if the data size is the problem, because the .doc files that
> are replicated are larger in size then the pdf files. Another thing I
> noticed is that I can replicate my pdf records in the 'faulty' database,
but
> only if I do an update of the record in my backend database. So when the
> record is 'new' the replication skips it, but if I update the record, by
for[vbcol=seagreen]
> example changing a letter in a description field, the replication picks up
> the record and pushes it towards the frontend database.
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:eJKebhuJEHA.3592@.TK2MSFTNGP09.phx.gbl...
> are
snapshot.[vbcol=seagreen]
> database.
> replicated,
replication[vbcol=seagreen]
> replicate
but[vbcol=seagreen]
idea[vbcol=seagreen]
would
> works
>

Database path contains an Extra Backslash.

I am very new to Sequel Server but we have a SQL 2000 server. One of the
paths inthe database has an extra slash i.e (C:\Progame files\\websense)
Vertias Backup can not back it up if it has an extra slhash. How can I
removed the the extra slas. I am still able to access the data base.
THanks,
MomWhere in the database? Are you refering to database properties where it
tells you the path of your .MDF, .NDF & .LDF files?
Somehow I doubt this has any effect on backup, but I've been wrong before.
"Jon Osborn" <josborn@.pcsii.com> wrote in message
news:uMiOKWjJIHA.5980@.TK2MSFTNGP04.phx.gbl...
>I am very new to Sequel Server but we have a SQL 2000 server. One of the
>paths inthe database has an extra slash i.e (C:\Progame files\\websense)
>Vertias Backup can not back it up if it has an extra slhash. How can I
>removed the the extra slas. I am still able to access the data base.
> THanks,
> Mom
>|||In enterprise manager I right click on the WS631 Database and select
properties.
On the Dara Files tab it has
Filename as ws631 with a location of D:\Program
FIles\Websense\\wslogdb63_1.mdf
Transation log is the same with .ldf at the end
Vertias says the \\ after websense is the problem.
Thanks,
Jon
"Jay" <nospam@.nospam.org> wrote in message
news:%23R8EGWlJIHA.3516@.TK2MSFTNGP02.phx.gbl...
> Where in the database? Are you refering to database properties where it
> tells you the path of your .MDF, .NDF & .LDF files?
> Somehow I doubt this has any effect on backup, but I've been wrong before.
> "Jon Osborn" <josborn@.pcsii.com> wrote in message
> news:uMiOKWjJIHA.5980@.TK2MSFTNGP04.phx.gbl...
>|||Is the data file in "D:\Program FIles\Websense\wslogdb63_1.mdf"?
If so, detach the db, or take the engine offline and change the path.
"Jon Osborn" <josborn@.pcsii.com> wrote in message
news:uTK2KE6JIHA.3672@.TK2MSFTNGP02.phx.gbl...
> In enterprise manager I right click on the WS631 Database and select
> properties.
> On the Dara Files tab it has
> Filename as ws631 with a location of D:\Program
> FIles\Websense\\wslogdb63_1.mdf
> Transation log is the same with .ldf at the end
> Vertias says the \\ after websense is the problem.
> Thanks,
> Jon
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23R8EGWlJIHA.3516@.TK2MSFTNGP02.phx.gbl...
>

Database path contains an Extra Backslash.

I am very new to Sequel Server but we have a SQL 2000 server. One of the
paths inthe database has an extra slash i.e (C:\Progame files\\websense)
Vertias Backup can not back it up if it has an extra slhash. How can I
removed the the extra slas. I am still able to access the data base.
THanks,
Mom
Where in the database? Are you refering to database properties where it
tells you the path of your .MDF, .NDF & .LDF files?
Somehow I doubt this has any effect on backup, but I've been wrong before.
"Jon Osborn" <josborn@.pcsii.com> wrote in message
news:uMiOKWjJIHA.5980@.TK2MSFTNGP04.phx.gbl...
>I am very new to Sequel Server but we have a SQL 2000 server. One of the
>paths inthe database has an extra slash i.e (C:\Progame files\\websense)
>Vertias Backup can not back it up if it has an extra slhash. How can I
>removed the the extra slas. I am still able to access the data base.
> THanks,
> Mom
>
|||In enterprise manager I right click on the WS631 Database and select
properties.
On the Dara Files tab it has
Filename as ws631 with a location of D:\Program
FIles\Websense\\wslogdb63_1.mdf
Transation log is the same with .ldf at the end
Vertias says the \\ after websense is the problem.
Thanks,
Jon
"Jay" <nospam@.nospam.org> wrote in message
news:%23R8EGWlJIHA.3516@.TK2MSFTNGP02.phx.gbl...
> Where in the database? Are you refering to database properties where it
> tells you the path of your .MDF, .NDF & .LDF files?
> Somehow I doubt this has any effect on backup, but I've been wrong before.
> "Jon Osborn" <josborn@.pcsii.com> wrote in message
> news:uMiOKWjJIHA.5980@.TK2MSFTNGP04.phx.gbl...
>
|||Is the data file in "D:\Program FIles\Websense\wslogdb63_1.mdf"?
If so, detach the db, or take the engine offline and change the path.
"Jon Osborn" <josborn@.pcsii.com> wrote in message
news:uTK2KE6JIHA.3672@.TK2MSFTNGP02.phx.gbl...
> In enterprise manager I right click on the WS631 Database and select
> properties.
> On the Dara Files tab it has
> Filename as ws631 with a location of D:\Program
> FIles\Websense\\wslogdb63_1.mdf
> Transation log is the same with .ldf at the end
> Vertias says the \\ after websense is the problem.
> Thanks,
> Jon
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23R8EGWlJIHA.3516@.TK2MSFTNGP02.phx.gbl...
>

Database path contains an Extra Backslash.

I am very new to Sequel Server but we have a SQL 2000 server. One of the
paths inthe database has an extra slash i.e (C:\Progame files\\websense)
Vertias Backup can not back it up if it has an extra slhash. How can I
removed the the extra slas. I am still able to access the data base.
THanks,
MomWhere in the database? Are you refering to database properties where it
tells you the path of your .MDF, .NDF & .LDF files?
Somehow I doubt this has any effect on backup, but I've been wrong before.
"Jon Osborn" <josborn@.pcsii.com> wrote in message
news:uMiOKWjJIHA.5980@.TK2MSFTNGP04.phx.gbl...
>I am very new to Sequel Server but we have a SQL 2000 server. One of the
>paths inthe database has an extra slash i.e (C:\Progame files\\websense)
>Vertias Backup can not back it up if it has an extra slhash. How can I
>removed the the extra slas. I am still able to access the data base.
> THanks,
> Mom
>|||In enterprise manager I right click on the WS631 Database and select
properties.
On the Dara Files tab it has
Filename as ws631 with a location of D:\Program
FIles\Websense\\wslogdb63_1.mdf
Transation log is the same with .ldf at the end
Vertias says the \\ after websense is the problem.
Thanks,
Jon
"Jay" <nospam@.nospam.org> wrote in message
news:%23R8EGWlJIHA.3516@.TK2MSFTNGP02.phx.gbl...
> Where in the database? Are you refering to database properties where it
> tells you the path of your .MDF, .NDF & .LDF files?
> Somehow I doubt this has any effect on backup, but I've been wrong before.
> "Jon Osborn" <josborn@.pcsii.com> wrote in message
> news:uMiOKWjJIHA.5980@.TK2MSFTNGP04.phx.gbl...
>>I am very new to Sequel Server but we have a SQL 2000 server. One of the
>>paths inthe database has an extra slash i.e (C:\Progame files\\websense)
>>Vertias Backup can not back it up if it has an extra slhash. How can I
>>removed the the extra slas. I am still able to access the data base.
>> THanks,
>> Mom
>|||Is the data file in "D:\Program FIles\Websense\wslogdb63_1.mdf"?
If so, detach the db, or take the engine offline and change the path.
"Jon Osborn" <josborn@.pcsii.com> wrote in message
news:uTK2KE6JIHA.3672@.TK2MSFTNGP02.phx.gbl...
> In enterprise manager I right click on the WS631 Database and select
> properties.
> On the Dara Files tab it has
> Filename as ws631 with a location of D:\Program
> FIles\Websense\\wslogdb63_1.mdf
> Transation log is the same with .ldf at the end
> Vertias says the \\ after websense is the problem.
> Thanks,
> Jon
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23R8EGWlJIHA.3516@.TK2MSFTNGP02.phx.gbl...
>> Where in the database? Are you refering to database properties where it
>> tells you the path of your .MDF, .NDF & .LDF files?
>> Somehow I doubt this has any effect on backup, but I've been wrong
>> before.
>> "Jon Osborn" <josborn@.pcsii.com> wrote in message
>> news:uMiOKWjJIHA.5980@.TK2MSFTNGP04.phx.gbl...
>>I am very new to Sequel Server but we have a SQL 2000 server. One of the
>>paths inthe database has an extra slash i.e (C:\Progame files\\websense)
>>Vertias Backup can not back it up if it has an extra slhash. How can I
>>removed the the extra slas. I am still able to access the data base.
>> THanks,
>> Mom
>>
>