Backup on Network Drive

Hi,
We want to take back up of databases on network drives. How should we do thi
s ?
- KetanIt is not generally recommended to backup directly to network drives. You
might be better off backup up to a local array, & then copying the file
across the network. There is a discussion on this here:
http://www.sql-server-performance.c...tore_tuning.asp
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||Use an UNC path in the destination file name. Make sure that the SQL Server
service account has
appropriate permissions on that share.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Ketan Patel" <ketanforever@.indiatimes.com> wrote in message
news:ua9$kQJ7DHA.2392@.TK2MSFTNGP11.phx.gbl...
Hi,
We want to take back up of databases on network drives. How should we do thi
s ?
- Ketan|||Thanks for your reply.
I have verified the service account. It was System account. I have changed
this to other having appropriate access to network drives and this works.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OqqmdWJ7DHA.3360@.tk2msftngp13.phx.gbl...
> Use an UNC path in the destination file name. Make sure that the SQL
Server service account has
> appropriate permissions on that share.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
>
> "Ketan Patel" <ketanforever@.indiatimes.com> wrote in message
> news:ua9$kQJ7DHA.2392@.TK2MSFTNGP11.phx.gbl...
> Hi,
> We want to take back up of databases on network drives. How should we do
this ?
> - Ketan
>
>
>
>|||I will vouch for that from experience.
:-)
Greg Jackson
PDX, Oregon