Link to home
Start Free TrialLog in
Avatar of Zolf
ZolfFlag for United Arab Emirates

asked on

Maintainance Plan - Backup db on network

Hello there,

I have a maintenance plan on mssql 2008 which takes db backup every hour on the server hard disk. Now I tried to take have another backup plan to be taken on NAS in the network,but it seems the sql server 2008 maintainace plan does not allow to take backup on devices in the network. Can somebody help me to take full db backup everyhour on another network device.

cheers
Zolf
SOLUTION
Avatar of btassure
btassure
Flag of United Kingdom of Great Britain and Northern Ireland 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
SOLUTION
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
Avatar of Zolf

ASKER

thanks for your comments.

>>make sure that the credentials used by the SQL Server service have permissions to the backup share.
can you please tell me how to check this

>>And check for the SQL Agent Service as well because that  account may/will be running your Maintenance Plan.
can you please tell me how to check this
ASKER CERTIFIED SOLUTION
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
Avatar of Zolf

ASKER

thanks