For over 20 years, backing up across a 100Mb LAN failed for me about
0.1% of the time, but that failure tended to be a hung process and
occasionally left a corrupted backup file. Pain from those ambiguous
failures was bad enough that I simply stopped doing it in environments I
was responsible for. I started doing it again a few months ago on a
Gigabit network, and have had no problems at all.

-----Original Message-----
From: Cheryl Bach
[mailto:mssqldba-ezmlmshield-x26177180.[Email address protected]
Sent: Tuesday, April 29, 2008 1:36 PM
To: LazyDBA Discussion
Subject: Re: backup to network

Na, you're not lucky - I've been backing up across the network for years
and have not had a problem ~ knock on wood ~ smile

Terry Crosby wrote:
> And remember, Microsoft does not recommend (nor do a lot of people)
backing up across the network as a spike during backup can corrupt the
backup file. They suggest a local backup and then copy the file across
the LAN. Having said that, I have successfully backed up across the wire
at a couple of different employers without issue. Maybe just lucky??!!
> ---------------------------------------------------------------------T
> O REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLYTo post a

> dba job: http://jobs.lazydba.comTo subscribe :
> http://www.LazyDBA.comTo unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>
>
>
>
>> To: [Email address protected] From:
>> mssqldba-ezmlmshield-x56521516.[Email address protected] Date: Tue,
>> 29 Apr 2008 10:03:43 -0500> Subject: RE: backup to network> > Jim,> I

>> would use UNC instead of drive letters. Additionally, you are going
>> to> only see local drives listed in EM. > > TSQL would be something
>> like this. Look at BOL for exact syntax.> Backup database XXXXX to
>> file '\\servername\c$\XXXX.bak' > > If you want to use IDE then
>> create a maintenance plan, go to backup tab and> it will let you
>> enter a UNC path when creating a backup plan. You can also> schedule,

>> etc. if you wish. Hope that helps. > > -----Original Message----->
>> From: Jim Hill> [mailto:mssqldba-ezmlmshield-x57515096.[Email address

>> protected] > Sent: Tuesday, April 29, 2008 8:32 AM> To: LazyDBA
>> Discussion> Subject: backup to network> > Guru's> > I was under the
>> impression that when set up SQL to use a domain account to> run SQL
>> service and agent under SQL20005 that I would be able to backup a>
>> database
>>
> to a network drive which I have mapped via explorer. When I try to>
> backup a database this way from management studio, the mapped drive
> does> appear as an option, only local drives are displayed for
> destinations of the> backup.> > any comment would be appreciated.> >
> Jim> > >
> --------------------------------------------------------------------->

> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY> To
> post a dba job: http://jobs.lazydba.com> To subscribe :
> http://www.LazyDBA.com> To unsubscribe:
> http://www.lazydba.com/unsubscribe.html> > > > >
> --------------------------------------------------------------------->

> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY> To
> post a dba job: http://jobs.lazydba.com> To subscribe :
> http://www.LazyDBA.com> To unsubscribe:
> http://www.lazydba.com/unsubscribe.html>
> ---------------------------------------------------------------------T
> O REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLYTo post a

> dba job: htt p://jobs.lazydba.comTo subscribe :
> http://www.LazyDBA.comTo unsubscribe:
> http://www.lazydba.com/unsubscribe.html
> _________________________________________________________________
> Back to work after baby--how do you know when you're ready?
> http://lifestyle.msn.com/familyandparenting/articleNW.aspx?cp-document
> id=5797498&ocid=T067MSN40A0701A
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post

> a dba job: http://jobs.lazydba.com To subscribe :
> http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>
>
>
>

--

Cheryl Bach ~ UITS - Computer Data Base Spec, Prin ~ Admin Computing ~
University of Arizona

"Happiness is a choice that requires effort at times."
-- Aeschylus

~~~~~~~~~~



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page