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
 Import/Export (DTS) and Replication (2000)
 Unable to copy the initialization file to ........

Author  Topic 

bobanjayan
Yak Posting Veteran

67 Posts

Posted - 2004-06-17 : 05:58:57
Hi friends,

I am trying to setup log shipping from Master_Server to Stand_by. I have shared Backup folder in Master_Server. I can access this folder from any PC in the netwok(//Master_Server/Backup).

In the final steps, the first step “Backup” occurs successfully without any problem. The second step fails with the error
“Unable to copy the initialization file to the secondary server.....

First I thought it is because of some network problem.

But when I try to do the same thing in same machine (Master_Server) it gives the same error.
Any idea about this??


RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-06-17 : 06:25:04
Does the SQLAgent account have rights to this directory??
Go to Top of Page

bobanjayan
Yak Posting Veteran

67 Posts

Posted - 2004-06-17 : 06:58:54
Yes,
I was using,
sa with same password in Master & Standby.
and Administrator also have the same password.

And moreover it is not running in the Master itself (I have mentioned).

The size of database backup is 10GB.
Backup schedule is every 15 min.
Copy/Load frequency 15 min.
Load delay 0 min.
File retention period. 24 hrs.

Backup alert threshold 45 min.
Out of sync alert threshold 45 min.

Is there any problem with this?
Go to Top of Page

bobanjayan
Yak Posting Veteran

67 Posts

Posted - 2004-08-12 : 06:47:15
I think this is a bug.
Go to Top of Page
   

- Advertisement -