|
|
|
April 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 agent profile and commandline parameter Posted by jeff_y at 8/28/2007 1:39:41 PM Hi gurus:
I have two questions:
1. If in 2nd step (Run Agent) of the distributor job, there is a parm, say
HistoryVerboseLevel 3, while I apply to the distributor a user-defined agent
proifle, which defines HistoryVerboseLevel 1, then what is the real value of
the distributor regarding this ...more >>
Snapshot folder Posted by How can I find the snapshot folder in SQL 2000, where would I look or if
there are sp to return the location.
Thanks
...more >>
error when using log shipping Posted by Roy Goldhammer at 8/28/2007 12:00:00 AM Hello there
I got an error when i run restore job:
Database 'some database' is not in Norecovery\standby mode.
what it that means? should i set it on database or in entire server?
...more >>
Setting log shipping Posted by Roy Goldhammer at 8/28/2007 12:00:00 AM Hello there
I have two databases with the same name at diffrent servers
Server1.DbTest, Server2.DBTest
I'm trying set log shipping between them so every update uccur in server1
will be don when the log ship occur.
When i set with restore at the Server2 it gave me an error that he can't
...more >>
when is Distribtutor Agent profile effective Posted by jeff_y at 8/27/2007 6:07:11 PM Hi gurus,
If I want to switch the distributor agent profile, for example, from the
system default profile to a new user-defined profile, I can do this from
Replication Monitor by Expanding a specific publication and then under "All
subscriptions" tab, right-click the subscription and select a...more >>
replication server crashed Posted by Darin at 8/27/2007 4:15:46 PM One of our customers had their publisher machine crash (harddrives went
down). This is running merge replicaton. The subscribers have continued
operating today.
Their network person "backed up the database". As of right now, I don't
know exactly what was backed up and how.
Can someone poin...more >>
Privilege needed for Merge replication Posted by Jay S. at 8/27/2007 7:48:04 AM Hi,
In order for merge replication to be setup I have created a SQL login on
both the publisher and subscriber and granted it System admin, Process admin
and Bulk Insert admin based on an article I read.
Question is it necessary to grant these server roles at the subscriber and
publishe...more >>
Continuous Replication updates every minute Posted by Aidan at 8/27/2007 12:00:00 AM Hi,
I have a setup a merge replication which is set to run continuously. At the
subscriber side I am seeing the tables updated every minute or so. Is it
possible increase the frequency of the replication?
SQL Server 2005
Standard
Thanks
Aidan
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Transation replication with updateable subscribers Posted by jueberro at 8/26/2007 11:04:00 AM I have a main database that I need to distribute a copy of to another server
for use by anotherb department to relieve load on the database server. Bothg
need to be except replicas at all times.
The database is currently hosted on a SQL Server 2005 Standard edition 64Bit
database server. ...more >>
The process could not connect to Subscriber Posted by Diane at 8/25/2007 10:00:01 AM I am in SSMS and have set-up replication (I think). I have connected Server A
and Server B in SSMS via SSMS Object Explorer. Server B is at another
location and is connect via VPN I believe.
Server A has the database I want to replicate somewhere else. I have setup
Server A to be Distribu...more >>
Login failed for user 'distributor_admin' Posted by Murali at 8/23/2007 11:48:00 PM Hi ,
We are facing trouble while setting up transactional push replication
between SQL 2000 and SQL 2005.
Publisher--SQL 2000
Distributir and Subscriber--SQL 2005 on same machine.
We are getting below error while running the Snapshot agent and while
expanding the publication from distr...more >>
Synchronizing data prior to initial snapshot Posted by sonyan NO[at]SPAM gmail.com at 8/23/2007 3:38:54 PM Hello folks,
I am trying to set up replication between a central office and
multiple sites. This will be merge repl, since either central or
satellites can be modified. However, one issue I ran into is setting
up subscribers. I don't always have the option of starting with a
publisher's snap...more >>
Best way to replicate my situation Posted by Diane at 8/23/2007 1:08:01 PM I have a Database at Location A that I want to Replicate to Location B once a
day at the end of the day.
Location B is really just for information purposes only EXCEPT 1 table which
gets updated during the day. I was thinking I could export the ne data daily
out and import it into A and th...more >>
updates delived as del/ins in SQL2005? Posted by Chris at 8/23/2007 9:56:00 AM
I noticed this behavior in SQL2000 transactional repl. Updates may get
replicated as deletes, then inserts.
Is this still the case in SQL2005 trans repl?
We would like to control deletes at the publisher, but not replicate those
deletes to the subscriber. This will be a problem w/ updat...more >>
The process could not bulk copy into table '"CCSYSTEM"'. Posted by Gav at 8/23/2007 6:00:00 AM Hi all,
I'm fairly new to SQL replication and I've been trying to setup a 'central
subscriber' topology using transaction replication.
First publisher went smoothly... second publisher, snapshot worked smoothly
but now is coming up with a distribution agent error:
The process could not ...more >>
creating manual NLB for replication Posted by Roy Goldhammer at 8/23/2007 12:00:00 AM Hello there
For a knowlage i have i can't install sql server on windows NLB clustering.
IF that so i have some idea how to improve performance using replication:
create 3 or more subscibers of my database for pooling data.
Create "Manual" technology that use more then one server for gettin...more >>
how to setup replication on sql2000 Posted by Dan Lewis at 8/22/2007 9:30:52 PM Can someone walk me through the simplest way to setup replication
between 2 sql2000 servers? I've never done it before and can't seem
to get it to work.
...more >>
Shared agent - how do I know which it is? How do I change it? Posted by bourgon NO[at]SPAM gmail.com at 8/22/2007 9:02:18 PM I am trying to consolidate replication - I have several dozen
publications that each go to anywhere from 1-20 subscribers.
Performance is not where I want it, and it appears to be tied to the
push subscriptions we have on the main machine. We have 3 options:
move to pull subscriptions, make a s...more >>
Replication Stops working on special Char Posted by Imran at 8/22/2007 9:56:00 AM Hi
We are running a replication on SQL 2005 Win 2K machine. We have modified
Store Procedures used by replication to block some columns getting replicated
under certain scenrios
The problem occures when these column contain '#' char. The replication
stopd working giving us error
Proced...more >>
Distribution db for Bidirectional Transactional Replication Posted by VS 2005 User at 8/22/2007 8:20:35 AM
SQL Server 2000: For Bidirectional Transactional Replication between
only 2 servers, should a distribution database exist on only one
server or on both servers?
Thanks
...more >>
Starting Snapshot Agent causes the DB machine to hang Posted by Wasyl at 8/22/2007 8:10:04 AM Hi,
When I try to start the snapshot agent for a transactional publication it is
hanging my database machine and makes it totally non-responsive until I have
to switch it off manually. Just now this happened and I restarted the
machine, tried to start the agent again and it became non-respon...more >>
REPLICATION with IP address instead Server Name Posted by K4Dude at 8/22/2007 3:34:09 AM Hi everybody,
I want to make a replication between two new SQL Server 2005 SP2 Servers.
Right now I'm doing it inside of my network. When i use the wizard y try to
set the publisher and the subscriber throw the IP instead of the Server Name.
But I can't. This is the error that I always get:...more >>
Could not find stored procedure Posted by damar3 at 8/22/2007 12:00:00 AM I have this error:
The row was inserted at 'DISTRIBUTION.db_main' but could not
be inserted at 'subscriber.db_test'. Could not find stored
procedure 'bp_ins_8284C429C5514F08046769C0F2D24607'.
How can I solve this problem?
Thanks.
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |