September 3, 2008 at 10:03 am
Backing up to a UNC path gives frequenly the dreaded
BackupDiskFile::RequestDurableMedia: failure on backup device Operating system error 64(The specified network name is no longer available.).
I know I'd be better off backing up to a local disk and copying across to the SAN based server for storage, but that doesn't help me when my free space is smaller than my backups at this point (I love inheriting things).
Since we're planning to replace the servers when we do a data center move in a few months, what I'd like is something I can point my network folks at... Since a small hiccup on the network can fry a SQL backup, but not a copy job. When we go to the new location I will get more servers with larger disk capacities or possibly replace the backup to disk jobs with a backup to storage array agent.
Any tips?
September 4, 2008 at 12:35 pm
Mark, you've got a pretty good handle and argument for why you shouldn't be doing what you obviously, short-term, have to be doing. SQL Server does not tolerate latency very well, hence the reason for not backing up over the wire. NIC cards should be good, links to the remote server(s) should be as fast as possible. Any disk issues on the remote server(s)? Any firmware updates needed for the NIC? Any possbility of moving a database to another server for the time being? Or archiving and data? Or have any log files grown to an unneccessary size that possibly can be shrunk? I'd seriously be pressing for the new hardware to be in place as quickly as possible, as I'm sure you are. If it's money or people-power constraints, I'd say you have enough valid reasons for them to find the money to buy the hardware or contract resources to get the job done sooner rather than later. Not having a good backup at the wrong time could be very costly to the business. Good luck.
-- You can't be late until you show up.
September 4, 2008 at 12:44 pm
Are you using SQL Servers BACKUP and RESTORE? You may want to consider purchasing a third-party backup solution that will allow you to compress your backups files during the backup process. There are 4 products out there you could use. Idera SQL Safe, Redgate SQL Backup, Quest Litespeed, and HyperBac HyperBac.
I am using HyperBac, and I am quite pleased with it.
I'd look at getting evaluation copies of them all (if management will allow) and do some testing to see if this will help.
😎
September 4, 2008 at 1:16 pm
may sound stupid, but would attaching a USB-drive (low cost high volume (up to 1 TB)) help out to make your local backup ?
Short term, very low cost.
And then xcopy it to your safezone.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply