SQL2008 Database back up to a Network Drive (NAS)

I am trying to generate SQL backups of databases to a mapped network drive (B:).

SQLServer does not seem to recognize the driver when I go located the drive folders to place the back file to it only shows local drives (C:,E:,D:).

I am sure there is a way to point backups to a network drive.

I am hoping someone can point me in the right direction.
armgonAsked:
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.

Chris WongCommented:
You should use a UNC to the directory to which you want to backup. ex: \\servername\share

Since mapped drives are only created on an interactive logon, if you schedule a backup to a mapped drive, the service account will not have access to it and fail.
0
Kent DyerIT Security Analyst SeniorCommented:
FYI..  A: B: are typically designated for old floppy drives - probably not an issue here..  Yes, most floppy drives have gone by the wayside..  One thing to keep in mind on a UNC, do not use an Admin Share e.g. \\servername\e$ as this typically will demand an domain admin at the minimum the admin of the server.   I would use the previous suggestion  of \\servername\share

HTH,

Kent
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
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.