Re: Snapshot Creation

Can you enable logging to see if it reveals anything.

http://support.microsoft.com/kb/312292/en-us

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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



"Jim" <please.reply@group> wrote in message
news:OFlSl1QrGHA.5008@xxxxxxxxxxxxxxxxxxxxxxx
Distributor/Publisher and Subscriber:
Windows Server 2003 SP1
SQL Server 2000 SP4

Distributor/Publisher and Subscriber created through SQL Server wizardry.
Asked for initial Snapshot to be created immediately. It wasn't.

Snapshot Agent shows as "Never started". Right-clicking on the Snapshot
Agent and selecting "Start agent" results in nothing--no snapshot, no
error message, no Event Log entries. Nothing.

I could really use some help here. I found one thread from March 2005
where a guy resorted to scripting what this replication is supposed to do.
I'd prefer to set it up to run as it is supposed to run. Is this
possible?

Thread from 2005:
http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/553cb851010ce48/b0e47aceeea46ee4?lnk=st&q=&rnum=2#b0e47aceeea46ee4

Thanks!

Jim

P.S. The replication manager is set to refresh every 10 minutes, and
each time the below error output appears in the Application Log.
Otherwise, I seem to have nothing at all going.
SQL Server Scheduled Job 'Replication agents checkup'
(0x44AB1206E3D37C428BD85CE9BBF50E59) - Status: Failed - Invoked on:
2006-07-21 16:20:00 - Message: The job failed. Unable to determine if the
owner (UAB\Genome-SQLServer) of job Replication agents checkup has server
access (reason: Could not obtain information about Windows NT group/user
'UAB\Genome-SQLServer'. [SQLSTATE 42000] (Error 8198)).








.

Relevant Pages

  • Re: SQL2005 FT error adding table column
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... When I click on "Columns" in the FT Index Properties pane, ... Microsoft SQL Server Management Studio ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Search Design
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... You will also get better performance by dedicating a catalog to each ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Creation of Indexes on the subscriber database
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... "Hilary Cotter" wrote: ...
    (microsoft.public.sqlserver.replication)
  • Re: Unable to create dynamic snapshot job
    ... SQL Server 2000 SP4, my apologies, forgot to mention that. ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... I am trying to re-create a dynamic snapshot job we once had on our ...
    (microsoft.public.sqlserver.replication)
  • Re: Transactional Replication 2005
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... subscriber b and then use subscriber B as a publisher to subscriber c. ...
    (microsoft.public.sqlserver.replication)