sc-w - Tuesday, January 24, 2017 4:06 AM

😉

John Mitchell-245523 - Tuesday, January 24, 2017 3:35 AM

sc-w - Tuesday, January 24, 2017 3:08 AM

Hi,

I have a need to setup log shipping across two networks thathave no domain relationship.  They aretwo separate work groups. I have been through every tutorial online to get thisworking but I am having an issue with what I believe is the permissions acrossthe two network/servers.

The actual setting up of the log shipping is fairly simple,I understand the logic. I can connect between the two SQL servers using IP addressport 1433 (I know this port is not secure I am just using it to get the logshipping working), so I can open databases from both sides no issues. So I don’tthink there is any firewall / connection related issues.

I have setup new window accounts on each server calledSQLSVC with the same passwords and set the SQL service Agents on both machineswith these new accounts (restarted the services also). I have given full readand write access to the two directories on each server that will hold the SQLlogs to these new accounts. On the primary server ‘A’ I have set the log foldedI created as shared with full permissions given to the local SQL service agent.I can allocate any additional permissions I need but I have even added (the everyone)account and given that full permission just to test.

Where it is falling over is when I do the ‘Save Log ShippingConfiguration’, it backs up the database on server ‘A’ ready to restore onserver ‘B’ and is at the restore step I get this error.

The SQL on both servers is exactly the same version. SQL 2008 R2

What am I missing? Any help would be really great thanks forlooking.

 

Restore backup to secondary database ….. ERROR….

 

TITLE: Microsoft SQL Server Management Studio

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

SQL Server Management Studio restore database ' testdb '

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

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQLstatement or batch. (SqlManagerUI)

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

Cannot open backup device '\\WIN-UC7TSJO3UEM\Log shipping\testdb.bak'.Operating system error 53(failed to retrieve text for this error. Reason:15100).

RESTORE FILELIST is terminating abnormally. (Microsoft SQLServer, Error: 3201)

Whenever you get an "Operating system error", go to a command prompt and type net helpmsg and the error number.  This particular error means "The network path was not found".  Are you sure that's the correct path?  What happens if you log on to the server and map a drive to \\WIN-UC7TSJO3UEM\Log shipping?

John

Thanks for the reply John,

Are you saying have the mapping going from destination B to source A or source A to destination server B or both? When I looked through all the online articles there was no mention of drive mapping but it makes sense that that there is a connection issue with copying the files.