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??!!
---------------------------------------------------------------------TO 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> ---------------------------------------------------------------------TO 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
_________________________________________________________________
Back to work after baby–how do you know when you’re ready?
http://lifestyle.msn.com/familyandparenting/articleNW.aspx?cp-documentid=5797498&ocid=T067MSN40A0701A
MS Sql Server LazyDBA home page