Re: backup over server

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
>
>
> .
>
>

MS Sql Server LazyDBA home page