Problem in configuring the Log Shipping

Question

When i try to configure log-shipping in Window Server 2003, It show the error like this

Restoring is failed for server SQLSERVER

An Exception is occurred while executing T-SQL or Batch

During the setup of warm standby database 'Sample', its standby file 'F:\Windows\System32\sample_09811675886.TFU' inaccessible to restore statement. The operating system error was 5[Access is denied] Diagnose operating system error, correct the problem and retry setup [error 3441].

Plz give suggestion to over come from this problem.

Regards,
RM Thirunavukkarasu
http://thiruna.blog.com

Answer 1

Hi Ramasamy ! 

This is a Duplicate thread of  "http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/f81887fa-2a6a-4b19-9c17-a5baf2a00ac5/" . Please donot create duplicate posts . SQLUSA has already replied for your question and please refer . 

-----------------------

Thanks,Suhas V

Answer 2

Hi Thiru,

The desination SQL Server's service account may not have required permission to access the folder in which the stand by file is located.

Regards, Balaji

---

Regards,Balaji, Please mark as answer if you think this answers your questions