Re: Snapshot Creation
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Mon, 24 Jul 2006 12:42:56 -0400
Make the job owner sa and start it up again.
--
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:uzV0dVzrGHA.3960@xxxxxxxxxxxxxxxxxxxxxxx
Hi again, Hilary! Thanks for the reply!
I have enabled logging, as you suggested at the level of "2". So all
activity should go to the log. Then I have again attempted to start the
Snapshot agent. No logs are created.
The Microsoft AD account under which the Snapshot agent (and other
replication-related agents) is (are) running had only "User" status. I
noticed in the Security Event log that it was being denied access to
directories and files in C:\WINNT\system32. So, I made it a "Power User",
and that helped. Then I made it an "Administrator" and that helped more.
But still no Snapshot agent log! :-(
I have since moved the AD account around some more between User, Power
User, and Administrator. Now no entries are appearing in the Security
Event log as they were before. I have changed nothing else. This is
weird! (and rather frustrating :-)
Any more suggestions, anyone?
Best regards,
Jim
"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:%23TNjnJRrGHA.2440@xxxxxxxxxxxxxxxxxxxxxxx
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)).
.
- Follow-Ups:
- Re: Snapshot Creation
- From: Jim
- Re: Snapshot Creation
- References:
- Snapshot Creation
- From: Jim
- Re: Snapshot Creation
- From: Hilary Cotter
- Re: Snapshot Creation
- From: Jim
- Snapshot Creation
- Prev by Date: Re: replication snapshot
- Next by Date: Re: Keep log file small
- Previous by thread: Re: Snapshot Creation
- Next by thread: Re: Snapshot Creation
- Index(es):
Relevant Pages
|
