Zolf
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
ASKER
>>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