Log shipping and compression
Fri, 19 Sep 2008 03:39:01 -0700
Here's the scenario....
I have a one-off database script that after completion results in the
production of some large transaction log backups for log shipping on SQL
Server 2005. In order that these backups do not take forever to copy from
primary to secondary, I wondered if it is possible to compress them ( ...
|
Cannot configure distribution database
Thu, 18 Sep 2008 12:08:01 -0700
Can someone help?
I had setup transactional replication and it was working great, but I had to
remove it due to some issues with the application/schema. Unfortunately, I
did not use the Wizard to remove the publisher/distributor and now when I try
to reconfigure replication I get this error message: ...
|
Cannot configure distribution database
Thu, 18 Sep 2008 12:01:01 -0700
HELP!
I had setup transactional replication and it was working great, but I had to
remove it due to some issues with the application/schema. Unfortunately, I
did not use the Wizard to remove the publisher/distributor and now when I try
to reconfigure replication it bombs out on me when configuring the
di ...
|
Is it possible to send binary data using RDA SubmitSQL method?
Thu, 18 Sep 2008 11:38:42 -0500
I have an application and I need to do an insert into the database but part
of the data is an image stored in the compact database. As long as I'm
inserting text data everyting is fine, however when I add the binary data to
my sql statement it ends up looking like the following:
"INSERT INTO eWorksheetSign ...
|
strange merge replication issue
Wed, 17 Sep 2008 23:39:01 -0700
We have a table(TAB1) with 3 triggers(UPDATE,INSERT & DELETE).
On any update on TAB1 the trigger updates same columns with the inserted
data in TAB2.
The triggers are : "NOT FOR REPLICATION"
TAB1 & TAB2 are in merge publication(same one)
Recently we had a strange scenario:
Update of TAB1(COL A)-> the update ...
|
SQL 2005 Merge Replication - Drops identity range constraint after
insert.
Wed, 17 Sep 2008 09:41:36 -0700 (PDT)
Hi All,
I have setup merge replication with sql 2005. I am trying to a add a
new table with a primary key (with NOT FOR REPLICATION set ) to the
replicated environment.
When I include the new table in the articles to be published i accept
the default table properties with regards to Indentity Range
Managem ...
|
Transactional replication fails with connection refused error
Wed, 17 Sep 2008 08:32:01 -0700
Hi,
I've setup transactional replication on 4 SQL Server 2005 clustered servers.
I have three different publications all configured as push with the
distributor running on the server with the publications. it looks like this:
Cluster 1 has 2 databases that have 3 publications -distributor is here
Clus ...
|
|
|
Merge Replication Fails with LOB Columns
Tue, 16 Sep 2008 15:51:01 -0700
We are having a problem with merge replication via the web. We usually get
the following message:
The merge process could not replicate one or more INSERT statements to the
'Subscriber'. A stored procedure failed to execute. Troubleshoot by using SQL
Profiler.
Occasionaly we get out of memory errors.
...
|
Table copy/import/move/replication
Tue, 16 Sep 2008 11:59:01 -0700
Hi
SQL server 2000 SP4 on both servers.
We have two applications on two separate servers with separate sql databases
on each server. One application needs to select data from another application
database (Only two tables). Both applications need to be online to users
without blocking. Because applicatio ...
|
Database Merging From one Server to Other
Mon, 15 Sep 2008 23:32:58 -0700 (PDT)
Hi All,
I have to Two Server Say X and Y.
Y has Data right from day1 to current.
while X has only current month records.
the frequency of merging will be after every 20 days.
My Query is how can we merge Records from X to Y, with following
condition
X --> can undergo Truncate or Deletion -- Y should n ...
|
