469,902 Members | 1,813 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,902 developers. It's quick & easy.

Log Shipping does not Ship to Secondary database


Could someone tell me what did i miss out in my steps when i configured our production database to our development database?

I tried on 2 separate servers and also between 2 separate instances on our development server, but it didn't work.No error after configuring Log shipping though.

Between the 2 servers - the transaction logs was backup every 1min on the pri server but log files just didnt transfer to secondary database.

Between 2 separate instances on the development server - transaction log was not even backup.

Both SQL Server 2005 workgroup edition resides on windows server 2003 and both are on work group environment (production server overseas while development server local),not domain.

Steps i took to configure log shipping:

1) Shared the folder that hold the backup file on the primary database server, even the SQL Agent was added to have read and write access.

2) Shared the folder that suppose to hold the copy transaction logs on the secondary database.

3) Restored the pri database to secondary database manually since using the wizard in object explorer doesn't seemed to work....

4)Used the object explorer wizard to configure log shipping with all the relevant network paths typed in.

Could it be that i didn't set any security settings between the 2 servers or the folders?

Hope someone help me out of this predicament.Thank you in advance!
Jun 25 '07 #1
0 996

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Tim | last post: by
4 posts views Thread by Jason Huang | last post: by
1 post views Thread by GB | last post: by
reply views Thread by Parveen.Beniwal.Daffodil | last post: by
6 posts views Thread by Chris Buckett | last post: by
1 post views Thread by madzambonis | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.