I have an application that has been using a right outer join that worked as I
expected until I added merge replication. On the replicated database the
result is the same as an inner join. I could be doing something odd but it's
a pretty plain use and it still works on instances of the database without
replication. I thought I'd first ask if this is a known issue before creating
small standalone files for posting.
Thanks
Kohn,
I see no reason how this could possibly be an issue. Please can you post up
your files and I'll try to repro.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Showing posts with label fail. Show all posts
Showing posts with label fail. Show all posts
Wednesday, March 28, 2012
Outer joins fail since adding replication
Labels:
adding,
application,
database,
fail,
iexpected,
joins,
merge,
microsoft,
mysql,
oracle,
replicated,
replication,
server,
sql
Wednesday, March 21, 2012
Out of disk space
We are having a ton of problems with a full backup. The db is 120 gigs,
there are 270 gigs free on the server and it continues to fail saying out of
disk space. Makes no sense.
Any ideas?
Thanks
Richard
What is the exact message? Are you sure the backup device is pointing to
the correct drive?
Andrew J. Kelly SQL MVP
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:eROSq$ANGHA.3908@.TK2MSFTNGP10.phx.gbl...
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out
> of disk space. Makes no sense.
> Any ideas?
> Thanks
> Richard
>
|||What is the size of the log file?
"Richard Douglass" wrote:
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out of
> disk space. Makes no sense.
> Any ideas?
> Thanks
> Richard
>
>
there are 270 gigs free on the server and it continues to fail saying out of
disk space. Makes no sense.
Any ideas?
Thanks
Richard
What is the exact message? Are you sure the backup device is pointing to
the correct drive?
Andrew J. Kelly SQL MVP
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:eROSq$ANGHA.3908@.TK2MSFTNGP10.phx.gbl...
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out
> of disk space. Makes no sense.
> Any ideas?
> Thanks
> Richard
>
|||What is the size of the log file?
"Richard Douglass" wrote:
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out of
> disk space. Makes no sense.
> Any ideas?
> Thanks
> Richard
>
>
Out of disk space
We are having a ton of problems with a full backup. The db is 120 gigs,
there are 270 gigs free on the server and it continues to fail saying out of
disk space. Makes no sense.
Any ideas'
Thanks
RichardWhat is the exact message? Are you sure the backup device is pointing to
the correct drive?
--
Andrew J. Kelly SQL MVP
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:eROSq$ANGHA.3908@.TK2MSFTNGP10.phx.gbl...
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out
> of disk space. Makes no sense.
> Any ideas'
> Thanks
> Richard
>|||What is the size of the log file?
"Richard Douglass" wrote:
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out of
> disk space. Makes no sense.
> Any ideas'
> Thanks
> Richard
>
>
there are 270 gigs free on the server and it continues to fail saying out of
disk space. Makes no sense.
Any ideas'
Thanks
RichardWhat is the exact message? Are you sure the backup device is pointing to
the correct drive?
--
Andrew J. Kelly SQL MVP
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:eROSq$ANGHA.3908@.TK2MSFTNGP10.phx.gbl...
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out
> of disk space. Makes no sense.
> Any ideas'
> Thanks
> Richard
>|||What is the size of the log file?
"Richard Douglass" wrote:
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out of
> disk space. Makes no sense.
> Any ideas'
> Thanks
> Richard
>
>
Out of disk space
We are having a ton of problems with a full backup. The db is 120 gigs,
there are 270 gigs free on the server and it continues to fail saying out of
disk space. Makes no sense.
Any ideas'
Thanks
RichardWhat is the exact message? Are you sure the backup device is pointing to
the correct drive?
Andrew J. Kelly SQL MVP
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:eROSq$ANGHA.3908@.TK2MSFTNGP10.phx.gbl...
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out
> of disk space. Makes no sense.
> Any ideas'
> Thanks
> Richard
>|||What is the size of the log file?
"Richard Douglass" wrote:
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out
of
> disk space. Makes no sense.
> Any ideas'
> Thanks
> Richard
>
>
there are 270 gigs free on the server and it continues to fail saying out of
disk space. Makes no sense.
Any ideas'
Thanks
RichardWhat is the exact message? Are you sure the backup device is pointing to
the correct drive?
Andrew J. Kelly SQL MVP
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:eROSq$ANGHA.3908@.TK2MSFTNGP10.phx.gbl...
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out
> of disk space. Makes no sense.
> Any ideas'
> Thanks
> Richard
>|||What is the size of the log file?
"Richard Douglass" wrote:
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out
of
> disk space. Makes no sense.
> Any ideas'
> Thanks
> Richard
>
>
Subscribe to:
Posts (Atom)