SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Log Shipping Copy Job successful but does not copy
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sql2005dba
Starting Member

8 Posts

Posted - 06/08/2011 :  13:40:53  Show Profile  Reply with Quote
Hello All,

I need to set up sql server 2000 log shipping between two servers. I just set up the maintenence plan from scratch. All the jobs were created on source and destination servers. Copy job on Destination shows successful but is not copying the new transaction files.

I see same question asked many times online but cannot find appropriate solution.

Can someone pls help ?!!

tkizer
Almighty SQL Goddess

USA
37134 Posts

Posted - 06/08/2011 :  13:45:46  Show Profile  Visit tkizer's Homepage  Reply with Quote
It's either a path problem or a security problem. Check the log shipping monitor tables and ensure the path is correct. Log into the database server using the SQL Server service account and check if it can read/write to that path.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

sql2005dba
Starting Member

8 Posts

Posted - 06/08/2011 :  15:44:12  Show Profile  Reply with Quote
Thank you Tara.

The sql server service account has admin rights on both servers.Can you please suggest me a way to test if SQL Server service account can read/write to a path ? Also , I need to do this check on log shipping destination sql server right?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37134 Posts

Posted - 06/08/2011 :  15:46:10  Show Profile  Visit tkizer's Homepage  Reply with Quote
On the secondary server, log into the database server using the SQL Server service account. Start..Run to the log shipping backup path and verify read/write privileges (write a file, read a file, any file will do even a text file). Let us know what you find.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

sql2005dba
Starting Member

8 Posts

Posted - 06/08/2011 :  16:16:21  Show Profile  Reply with Quote
Here is the whole scenario:

There are 3 servers in picture A, B, C . These are in same domain.

B used to be a Log Shipping source for C. Both sql servers run under same service account lets say sa1. Now we have a new server A . We want A to be the Log Shipping source for destinations B and C . Sql server on A runs under different service account sa2. Log Shipping is established between A and B successfully with A as source . Now I want to add C as a destination to the already established Log Shipping . I added C as destination but copy job didn’t work on C . It shows successful but doesn’t copy . Now I deleted everything from all three servers related to this maintenence plan and created a new maintenence plan for Log Shipping from A to C . Copy job still don’t work. So there must be something missing between server A and C.

I don’t have password for service accounts so cannot test them personally for file read write .But the windows administrator says that these accounts have admin rights on both servers. Is there anything else that I can do in this situation??


It is very thoughtful of you to read and analyze my problem. Thanks for that!

Edited by - sql2005dba on 06/08/2011 16:40:00
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37134 Posts

Posted - 06/08/2011 :  17:13:57  Show Profile  Visit tkizer's Homepage  Reply with Quote
You can't just add C to an existing log shipping environment without properly initializing it.

Have the administrator do the testing I mentioned. We must validate permissions and the path as that is 99% of the time the problem. Either the path isn't defined properly (like a typo or didn't use a UNC path) or it's permissions.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000