I concur with Jay as we tried to back up to the NAS and it had mixed
results. The UNC path is a better way to go as he is right as far as a
mapped drive and user sessions.
I misspoke when I said map a drive as I use a UNC path.


Christopher Bellizzi
SQL DBA/Programmer
240 Falls Street
Seneca Falls, NY 13148
Phone: (315) 568-7886
Email: Christopher.[Email address protected]

-----Original Message-----
From: Jay Butler
[mailto:mssqldba-ezmlmshield-x60977856.[Email address protected]
Sent: Monday, January 30, 2006 10:51 AM
To: LazyDBA Discussion
Subject: Re: backup over server

Mapped drives belong to the user session. They are not available to the
services.

Even if you could, I would avoid backing up directly to network devices.

I have had bad experiences in the past trying to backup to a NAS. SQL
Server would report that the backups were successful. The files were the

correct size. But, more often than not, the files were corrupt. Restores

would fail at some point because of this.

As Christopher suggests, I would backup locally then copy the files
across the network. You should still use the UNC path for the file
destination.


Jumma Salim wrote:
> Can I make a backup plan to backup to a different server by mapping a
> drive to database server say T drive
>
>
>
> Mapped drive does not show when I make Maintenance plan?
>
>
>
>
>
> If I do through query analyzer it will not do all step that I can
easily
> do in maintenance plan?
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
> .
>
>


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


************************************
This e-mail and any files transmitted with it are proprietary and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender. Please note that any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of ITT Industries, Inc. The recipient should check this e-mail and any attachments for the presence of viruses. ITT Industries accepts no liability for any damage caused by any virus transmitted by this e-mail.
************************************


MS Sql Server LazyDBA home page