Link to home
Start Free TrialLog in
Avatar of klwn
klwnFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL2005 - Backup database to shared network location using maintenance plan

I'm trying to backup to a shared network location using the backup task within maintenance plans. The instance is connected to a local account and I'm able to navigate and write to the directory on the SQL Server. When I execute the plan I receive a successful result but when navigating to the directory it's blank. The SQL version is SP3.

Any help is very much appreciated.

Regards
Dax
Avatar of Sanjay Santoki
Sanjay Santoki
Flag of India image

Hello,

If you are taking backup service account should have write permission on the network resources.

THanks,
Sanjay Santoki
Avatar of klwn

ASKER

Hi - Just to clarify we are using Windows authentication to launch Management Studio using a local windows account. We have already proven that write permissions are active as we have been able to create a new file within the folder for the shared resource.
Please see screen shot below:

 User generated image
ASKER CERTIFIED SOLUTION
Avatar of Sanjay Santoki
Sanjay Santoki
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial