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
zolfAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

btassureCommented:
You should be able to just back up straight to the UNC path when you are configuring your backup (\\server\share)

If it complains that it cannot find the path and you have verified it is working in Explorer on the SQL server, make sure that the credentials used by the SQL Server service have permissions to the backup share.
0
lcohanDatabase AnalystCommented:
And check for the SQL Agent Service as well because that  account may/will be running your Maintenance Plan.
0
zolfAuthor Commented:
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
0
btassureCommented:
Open Computer Management (Start - Run - compmgmt.msc) and expand Services and Applications, then go to the SQL Server section. You might need to delve a bit deeper depending on your 32 or 64 bit flavour, but in there you will find all the SQL services, including the SQL Server Service and the SQL Agent Service. In one of the columns it will tell you the user account for the services. It will either be a proper user account or it will be network/system service.

Next, go to the security permissions tab on the folder (and the share permissions) that will be holding your backups on the network and check that the account listed in the section above has full control (or at least write etc). You can verify that in the effective permissions tab.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
zolfAuthor Commented:
thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.