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.
| Author |
Topic |
|
manju3606
Yak Posting Veteran
78 Posts |
 Posted - 2011-09-02 : 13:32:10
|
| I am trying to setup the Log Shipping between two SQL Server 2005 instances which stay on different Windows-2003 servers. Both have exact same verion of OS and SQL Server installations [in fact, they are VMs]. Both the systems can talk and user on one box can create/delete the files on other box.It is strange that it is complaining the about the file which is on the local drive and which has full permissions.Primary Server:SQLhescom =>Windows-2003, SQL Server 2005Secondary/Server:SQLhescomlog=>Windows-2003, SQL Server 2005The error I am getting is,===================================Cannot open backup device '\\SQLhescom\backup folder\logshipDb.bak'. Operating system error 5(Access is denied.).RESTORE FILELIST is terminating abnormally. (.Net SqlClient Data Provider)------------------------------The error is coming when I am telling it to backup current, restore onto another server and set the secondary as Standby.[I tried the other way also; means, creating the primary and standby databases on the servers and then also there was transaction log shipping problem]Can anybody tell me what I am missing here for the Log Shipping configuration.Any suggest is well appreciated.ThanksManjunathManju |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
ERROR IN LOG SHIPING