September 21, 2010 at 10:25 am
Question
As a normal we can take sql server 2005 database backups to local disk in server.
Is it possible to take backups directly to a network drive or a third patry online disk(Jungle Disk)
Appreciate your help. Thank you.
September 21, 2010 at 10:32 am
A backup can be written to any FULL UNC Network path that you have access to.
you can also write to a network drive by mapping it if you don't want to use the full UNC path.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
September 21, 2010 at 10:57 am
You can take the backup to local drive and then move it to the network drive. With you can minimize the risk of having corrupt backup files
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 21, 2010 at 11:26 am
You can backup out to a UNC path, but, it's usually not a good idea because then you're dependent on the network to handle the backup and that can sometimes cause issues. Usually it's better, where you can, to backup to a local drive and then copy it over, as was suggested.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 23, 2010 at 9:04 am
We have a space issue in drive. No space for backups.
I could see the network drive in MyComputer. How can I know whether it is UNC network drive.
I tried to take backup to network drive, but I could not see the network drive in destination path select window, only local drives are visible.
For the time being, I want to take backups to network drive untill we add the space to local drive.
THnak you.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply