all groups > sql server replication > may 2004 >
You're in the

sql server replication

group:

Log Shipping Copy Job reports successful, but copies nothing


Log Shipping Copy Job reports successful, but copies nothing gregasp NO[at]SPAM yahoo.com
5/27/2004 3:21:58 PM
sql server replication:
No luck. I tried as suggested but still get no love. Exact same issue.

Additional info:
both servers are in a workgroup not on a domain.

Here is the output from the copy job as seen in the job history:

The job succeeded. The Job was invoked by Schedule 100 (Schedule 1).
The last step to run was step 1 (Log Shipping Copy).

Executed as user: local\userid. output

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(null)
Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.760
Re: Log Shipping Copy Job reports successful, but copies nothing Gregory Asplin
5/28/2004 1:17:07 PM

Ok. I created a cmdexec job to copy the file and it worked just fine.

Bizarre.

I can always alter the job to not execute the maintplan in favor of a
simple copy step I suppose but I don't understand why the log shipping
job wont work identically.

-G

*** Sent via Developersdex http://www.developersdex.com ***
Re: Log Shipping Copy Job reports successful, but copies nothing Paul Ibison
5/28/2004 8:38:10 PM
Gregory,
I can't put my finger on this issue. Perhaps you could try testing things
indirectly. Can you create a job on the standby server which uses a cmdexec
step to copy a file from the production server's share to the local
directory. Schedule the job then see if it works. Hopefully it won't but it
will report more useful error info.
Regards,
Paul Ibison

Re: Log Shipping Copy Job reports successful, but copies nothing Paul Ibison
5/31/2004 1:46:02 AM
Gregory
to get it going you could rely on your manual job but as you say it's fustrating not knowing why this doesn't work normally. The offer still stands if you want to send me screen shots of your steps through the setup wizard - just to give the setup configuration a clean bill of health
Regards
AddThis Social Bookmark Button