MS SQL Server - Daily Backups SQL 2005 Standard Edition

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Daily Backups SQL 2005 Standard Edition

Chris Marsh

2006-02-11, 8:23 pm

With SQL 2000 I was backing up to a NAS server by mapping a drive share to
Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
focused on a networking issue?

Thanks!

Chris

Andrew J. Kelly

2006-02-11, 8:23 pm

Backups are always done with the privileges of the account SQL Server is
running under. Does this account have access to that share? You never want
to use mapped drives. Use UNC pathing instead.

--
Andrew J. Kelly SQL MVP

"Chris Marsh" <cmarsh@synergy-intl.com> wrote in message
news:eRk0J22LGHA.420@tk2msftngp13.phx.gbl...
> With SQL 2000 I was backing up to a NAS server by mapping a drive share to
> Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
> focused on a networking issue?
>
> Thanks!
>
> Chris
>

Sponsored Links