November 10, 2008 at 5:25 am
Hi All
Please tell me how to take backup in a network drive please by giving me full explanation please ....
November 10, 2008 at 5:45 am
You can use a UNC path name fo rthe backup file :
backup database foo to disk='\\myserver\sharenam\foldename\foo.bak'
But frequently it is better to back up to a local disk and then copy the backup file to the network share.
Mike John
November 10, 2008 at 5:46 am
Try like this:
* First you can create one folder in network drive and share it with full permission.
* Map the network drive (ex: created above folder)
* Open the SQL Server Management Studio, select the database to backup and choose backup path (i.e. select the mapped network drive).
November 10, 2008 at 12:05 pm
The backup process throws pages out as quickly as it can. It has no tolerance for delays because of the nature of the backup. It is NOT anything like a file copy. If the network hiccups, which happens all the time, the backup fails. File copys retry and go on.
Don't do this. Back up locally and copy to the network.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
November 10, 2008 at 12:30 pm
We always take backups to local disk, the xcopy the bak files to a UNC-resource (safezone).
If you've run out of disk slots to add more disks, you may even consider to add a USB disk and use it for local backup.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 16, 2008 at 3:56 am
please tell me how to give full permission right to that folder,i have to give any sql server permission like login account or some thing like that bcz my back up goes fail again and again plz explain in detail brother thanx ...plzzzzzzzzzzzzz
November 17, 2008 at 7:33 am
The login account running the SQL Server service will need access to the network share you are using. If your server is using the Local System account to run SQL Server, it will not have access to any network resources. Once you have restarted the SQL service using a domain account, you can create a network share and give the new domain account the proper permissions to write to it.
As some others have noted, this type of backup may experience network issues. In my case, however, I backup hundreds of db's directly to a NAS device and rarely experience an I/O error. I do have to be careful to to distribute the backups across my backup window. I have had issues when several large DB backups occurred at the same time and overwhelmed the NAS device.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply