Hello there
After i've created my replication I aslo create script for recreating it
again.
However, After i create the replication again the names of my Jobs are being
changed.
Is there a way to create constant name to the replication jobs?
Roy,
not as far as I know. However provided you know the name of the publication,
you can determine the name of the jobs after replication is set up and use
it in code.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||This is to prevent two jobs having the same name. There is a "bug" where if
you create two publications with the same name in different database your
agents will disappear in the agents folders. You can still pass the names
you want in your script using the agent_names parameter.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:OQocpByAGHA.324@.TK2MSFTNGP10.phx.gbl...
> Hello there
> After i've created my replication I aslo create script for recreating it
> again.
> However, After i create the replication again the names of my Jobs are
> being
> changed.
> Is there a way to create constant name to the replication jobs?
>
Showing posts with label agents. Show all posts
Showing posts with label agents. Show all posts
Sunday, March 11, 2012
Controling Names of Agents
Labels:
agents,
aslo,
controling,
create,
created,
database,
itagain,
ive,
microsoft,
mysql,
names,
oracle,
recreating,
replication,
script,
server,
sql,
thereafter
Wednesday, March 7, 2012
content of REPLDATA directory
Hi!
There are collecting snapshot agents (SQL7.0) generated files in the separate directories (named like 20030923020007, 20030716020008, and so on) in my ReplData directory.
Why does count of such directories increase without interruption?
Can I delete directories with old date of modifying from my C:\MSSQL7\REPLDATA\unc\ directory?When a snapshot is recreated, SQL will make a new subfolder with datetime stamp as its name to put the data in Repldata folder. There should be a clean up job to delete the subfolder once the snapshot is delivered. My guess is the process has been interrupted so the cleanup step was not completed. You can delete the subfolder since it's no longer being used.
There are collecting snapshot agents (SQL7.0) generated files in the separate directories (named like 20030923020007, 20030716020008, and so on) in my ReplData directory.
Why does count of such directories increase without interruption?
Can I delete directories with old date of modifying from my C:\MSSQL7\REPLDATA\unc\ directory?When a snapshot is recreated, SQL will make a new subfolder with datetime stamp as its name to put the data in Repldata folder. There should be a clean up job to delete the subfolder once the snapshot is delivered. My guess is the process has been interrupted so the cleanup step was not completed. You can delete the subfolder since it's no longer being used.
Subscribe to:
Posts (Atom)