Shared folder does not exist

vad2319

I am using trial evaluation of SQL Backup. so far it has been good, but had a problem today morning.

While setting up log shipping, At step 4 of 6: Specify a network share accessible from both SQL Servers.

I wrote:
Networkshare:\\Computername\shared

And then on clicking "Test", previously it used to give a message that "both the servers have required permission to use this shared folder". but from today morning its giving a message that the "folder does not exist".

I am pretty sure that the folder does exist & has the same permissions as were yesterday & days before.

Please advise why suddenly Sql Backup does not detect any shared folders?

I can go to Windows Explorer & access the same shared path.

Thanks in advance.

petey

SQL Backup uses the credentials of the SQL Backup Agent service startup user to access network shares. Try accessing the network share using that account via Windows Explorer and see if you get the same error.

vad2319

How can I find the credentials of the SQL Backup Agent service startup user?

Is it the Login information for the server on which sql server is installed?

Do you think restarting SQL Backup Agent service would be useful?

Thanks.

petey

On the server where SQL Backup is installed, open the Windows Services applet. There should be a service named SQL Backup Agent. Note down the Windows account name that the service is started with. That is the account you should try logging in to Windows with and see if you can access the network share.

Restarting SQL Backup should not have any effect, though there's no harm in trying. Just ensure no backups are running at that time.