Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Log Shipping (+)

Author  Topic 

Kezya
Starting Member

2 Posts

Posted - 2008-09-12 : 10:07:05
Hello!

Sorry for my poor english :(

I have two MS SQL Server 2000 Enterprise Edition with SP4. Setup on server Log Shipping Database. All jobs finish succesfully (backup, copy and restore) but number on copied files is 0 (and restoring also 0). On monitor server view copy/restore history: always copied first initialization log backup file.
Why???
Help me please!
Thanks a lot!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-13 : 23:43:15
Was Full backup restored on Secondary server with Norecovery/Standby option?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-13 : 23:50:33
Did you setup the share properly and does the SQL Server service account have permissions to it?

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

Subscribe to my blog
Go to Top of Page

Kezya
Starting Member

2 Posts

Posted - 2008-09-15 : 05:58:39
Thanks for Tara Kaizer! I find old topics about LS and follow you advise.
Share folder for primary servers backup did not set properly.
Shame on me :)
Go to Top of Page
   

- Advertisement -