Backup to networkdrive possible?

I can only see my local drive(s). I have mapped 2 networkshares but
can't see them when trying to choose a location for my backup. Can a
filebackup be made directly to a mapped (or non-mapped) networklocation?
Tnx,
Hans Brouwer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Yes. You must manually type the UNC name for the target. Do not use drive
mappings since SQL may not know about them. Also, the SQL service account
must have rights to write files in the target directory.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"hansje" <hansjes@.anonymous.com> wrote in message
news:OFVHba0rDHA.2456@.TK2MSFTNGP12.phx.gbl...
> I can only see my local drive(s). I have mapped 2 networkshares but
> can't see them when trying to choose a location for my backup. Can a
> filebackup be made directly to a mapped (or non-mapped) networklocation?
> Tnx,
> Hans Brouwer
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Hi ,
To add on to geoff's mail.
You can map the drive and use it in Query Analyzer along with Backup
statement.
Say your network server name FINANCE and the drive is k$ then use the below
statement to backup,
Backup database HRMS to disk='\\FINANCE\k$\MSSQL\BACKUP\HRMS_BACKUP.BAK with
init
The below statement will succed provided you have rights on that drive.
Thanks
Hari
MCDBA
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:#vUJ$e0rDHA.2084@.TK2MSFTNGP12.phx.gbl...
> Yes. You must manually type the UNC name for the target. Do not use
drive
> mappings since SQL may not know about them. Also, the SQL service account
> must have rights to write files in the target directory.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
>
> "hansje" <hansjes@.anonymous.com> wrote in message
> news:OFVHba0rDHA.2456@.TK2MSFTNGP12.phx.gbl...
> > I can only see my local drive(s). I have mapped 2 networkshares but
> > can't see them when trying to choose a location for my backup. Can a
> > filebackup be made directly to a mapped (or non-mapped) networklocation?
> >
> > Tnx,
> >
> > Hans Brouwer
> >
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!
>