Log shipping error "Folder Does not exist" for shared pathh

Compresses, encrypts, secures and monitors SQL Server backups.

Log shipping error "Folder Does not exist" for shared pathh

Postby raj_technoman » Fri Feb 28, 2014 10:49 am

Hi There,

I try to set log shipping and on third step of my log shipping ,
when I try to input any shared path in "Network Share" text box.
It always say "Folder Does not exist" .

That folder has read/write permission for "Everyone" and folder is browse from "Network Share"'s browse button only.

In Red Gate it said "Folder Does not exist" but same folder is valid folder from "SQL Log Shipping".

Please reply us ASAP.

Thanks,
Rajendra
raj_technoman
 
Posts: 7
Joined: Tue Feb 18, 2014 6:19 pm

Postby eddie davis » Mon Mar 03, 2014 12:08 pm

Thank you for your forum post.

Despite and I quote:
That folder has read/write permission for "Everyone" and folder is browse from "Network Share"'s browse button only.


The error message does indicate that the account given to the SQL Backup Agent does not have security permissions to the network share folder.

Run the following query to ensure that the account has sufficient given to the SQL Backup Agent has permissions on the network share:
Code: Select all
EXECUTE master..sqbutility 999, 'RWE', '<network location>'


Replace <network location> with the unc path to the network share.

If this is successful and the SQL Backup Agent service has read (R), write (W), and execute (E) permissions, the query will return:

<SQBUTILITYRESULT>:1:

If there is a problem, the query will return a value of 0, followed by a message, for example:

<SQBUTILITYRESULT>:0:Folder does not exist :
<network location>

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 998
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Log shipping error "Folder Does not exist" for shared path

Postby raj_technoman » Fri Mar 14, 2014 1:31 pm

Hi Eddie,
Apologies for very late reply.

Please find my SP and execution result as per below,

SP:
EXECUTE master..sqbutility 999, 'RWE', '\\\\Rym-db-svr\\RedGateLogShipping'

Result:
<SQBUTILITYRESULT>:1:

So means that I gave correct path and user has correct permission also.

But Logshipping’s step 3 still say that “Folder Does not existâ€
raj_technoman
 
Posts: 7
Joined: Tue Feb 18, 2014 6:19 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests