Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

TRANSACTION LOG COPY JOB FAILED IN LOGSHIPPING Expand / Collapse
Author
Message
Posted Wednesday, December 4, 2013 11:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 7:37 AM
Points: 37, Visits: 40
Hi All,

I am facing copy job failed error in log shipping. when i configured logshipping backups are occurring normally, but the issue is when the secondary server searches for logfile in primary server that time it was showing

error : the network path was not found

my primary server name like this: ITI-PDP-DB\chandu
i am given the primary server network path like:\\ITI-PDP-DB\chandu\Logshipping_backup

if i give ip then it was showing error : the network path \\192.168.0.21\Logshipping_backup was denied.


please help us

Thank & Regards
Chalapathi
Post #1519727
Posted Wednesday, December 4, 2013 10:24 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
Are you reffering named instance like this "ITI-PDP-DB\chandu"

first try the network path in windows , if it is not working check and fix it.

can provide more details like server1 and server2 with masked info and what are you trying with that.


Regards
Durai Nagarajan
Post #1519863
Posted Thursday, December 5, 2013 12:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 5, 2014 6:19 AM
Points: 147, Visits: 591
make sure your SQL service account has the rights to access network path.



Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com
Post #1519887
Posted Thursday, December 5, 2013 12:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 7:37 AM
Points: 37, Visits: 40
Hi durai nagarajan,


ya exactly its a named instance i have given the windows path also
like \\192.168.0.21\foldername at that time i am getting

error: the path \\192.168.0.21\foldername is denied error please help me




Thanks
Chalapathi
Post #1519889
Posted Thursday, December 5, 2013 1:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 5, 2014 6:19 AM
Points: 147, Visits: 591
give SQL service account full access to this folder



Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com
Post #1519899
Posted Thursday, December 5, 2013 1:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 7:37 AM
Points: 37, Visits: 40
Hi Praveen,



I had given those permissions also,still it was showing same error, please help us.




thanks & regards
Chalapathi
Post #1519906
Posted Thursday, December 5, 2013 1:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 5, 2014 6:19 AM
Points: 147, Visits: 591
basically from your secondary server you should be able to access backup folder, try to login to your secondary server with SQL Service account user name and password and then try to access backup folder

Start -> Run -> \\servername\foldername

if you are not able to access this folder than you have not given enough permission to this account.





Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com
Post #1519908
Posted Thursday, December 5, 2013 3:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:56 PM
Points: 6,365, Visits: 13,695
cpathidba (12/5/2013)
Hi Praveen,



I had given those permissions also,still it was showing same error, please help us.




thanks & regards
Chalapathi

It is the SQL Server agent service account that requires access to the share. Also, ensure you check both Share and NTFS permissions and set them appropriately


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1519935
Posted Monday, December 23, 2013 1:41 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, September 7, 2014 5:20 PM
Points: 100, Visits: 356
got fixed?
Post #1525625
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse