Backup to an USB Device

Hi:
Can anyone help me with backing up SQL Server Databases to a Shared USB
Device over a Network. I am able to Map the USB Drive on the machine. However
when I am trying to configure Backup using the Maintainence Wizard it does
not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
Server SP1. Please let me know if this is possible.
Thanks
MitulHi,
You'll have to enter the UNC path to the device and then the account
that runs SQL server needs to have permissions to the share.
You problem right now is most likely that you have mapped the USB drive
with a different account than SQLserver/SQL server agent runs under and
that's why it doesn't appear.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Mitul Z wrote:
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine. However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul|||http://support.microsoft.com/kb/555128
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine.
> However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul|||Thanks for the reply.
The article states that this needs to be configured with a Domain account.
However we don't have an domain environment, then will SQL Server Services
running under Administrator Account suffice.
Thanks
Mitul Z
"Geoff N. Hiten" wrote:
> http://support.microsoft.com/kb/555128
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
> news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
> > Hi:
> >
> > Can anyone help me with backing up SQL Server Databases to a Shared USB
> > Device over a Network. I am able to Map the USB Drive on the machine.
> > However
> > when I am trying to configure Backup using the Maintainence Wizard it does
> > not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> > Server SP1. Please let me know if this is possible.
> >
> > Thanks
> > Mitul
>|||The domain acount is necessary to access network resources. It provodes a
common security context. Administrator is only valid for the local machine
and has no meaning across the network. In short, no, it won't work
reliably.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:3F91A798-3779-4A21-A91C-983E3024A645@.microsoft.com...
> Thanks for the reply.
> The article states that this needs to be configured with a Domain account.
> However we don't have an domain environment, then will SQL Server Services
> running under Administrator Account suffice.
> Thanks
> Mitul Z
> "Geoff N. Hiten" wrote:
>> http://support.microsoft.com/kb/555128
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>> "Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
>> news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
>> > Hi:
>> >
>> > Can anyone help me with backing up SQL Server Databases to a Shared USB
>> > Device over a Network. I am able to Map the USB Drive on the machine.
>> > However
>> > when I am trying to configure Backup using the Maintainence Wizard it
>> > does
>> > not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
>> > Server SP1. Please let me know if this is possible.
>> >
>> > Thanks
>> > Mitul
>>