July 9, 2023 at 4:08 pm
In my home office (SQL Server DBA, now a 13-year retiree) I have two NAS devices, a D-Link DNS-343 (4x2TB) and a WD EX4100 (4x10TB).
I had to take the WD NAS off my surge protectors due to repeated 'power supply failure' notices, and it has worked since with no problem.
My Win 10 machine suddenly in the middle of a 2TB copy from a docking station, lost connection to the D-Link, all four mapped drives disappeared and would not come back. All of the WD NAS drives remained available through this. In researching the problem, and several network restarts, I see that the IP address of the D-Link device has changed for some unknown reason, and I could no longer ping either the old nor the new IP. Trying my NET USE DOS scripts reported failure on all four D-Link drives. Windows could not see the device on the network, and the setup application for the DNS-343 would not find the device. Potentially I had lost 8TB of backups and bulk storage.
Amazingly and fortunately, after working on this for several hours and then the machines sitting idle for about six hours, the four missing drives mapped have magically re-appeared in Windows.
Now the scary part is that while the four drives are JBOD, not raid, I cannot just put a drive in my docking station because Windows doesn't recognize the format used by the NAS.
Does anyone have a recommendation for a NAS device I can use as JBOD that uses the standard Window format so I can move drives from the NAS to a docking station or another desktop machine. Or is there a multi-disk docking station or NAS that you recommend? I do have an Insignia (Best Buy brand) two-disk USB SATA docking station that works well if I should go that route. I use it along with a USB docking strip that accommodates six USB drives and two 3.5" disks, but they aren't on the network. The D-Link NAS has discontinued support but I didn't know that when I purchased it a couple years ago.
Yes, I know my network has gone out of control...but we're down to five windows machines.
Rick
Disaster Recovery = Backup ( Backup ( Your Backup ) )
July 10, 2023 at 4:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
July 10, 2023 at 5:16 pm
I do not have a recommendation. But this may be a better question to pose on a site like Toms Hardware or something similar.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 12, 2023 at 6:01 am
No recommendations on hardware. Maybe you can pick up another dlink box on ebay.
Some years ago I replaced the OS on my dlink box with Alt-f, mainly to get support for SMB v2 for my home Windows domain. It did the job and has been rock solid.
Is it just possible that your loss of your drives might be related to Windows having a hissy fit with SMB v1 for a while. Changing to Alt-f would avoid this problem. If you do upgrade remove your drives before starting to ensure no a cidental over-writes.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
July 12, 2023 at 1:56 pm
Ed, I didn't know that OS change could be done. Some of this stuff gets to be 'over my head' ( or maybe I'm getting lazy ). I'm still considering going back to just seperate disks either using a 6-port USB stick or using SATA drives in the docking station with a calendar schedule of rotating and refreshing copies to removables. Remember the old IBM-days wisdom of using the KISS method (keep it simple, Stupid). I'm already using four of the USB ports for multiple copies of bulk items. Made my own 'NAS' in a little wooden hobby box with shelves for the USB drives, and I can switch them on/off as needed. And I can buy several new USB drives for the cost of another unpopulated NAS. I'm not doing a lot of real-time stuff on the NAS devices since my Asus laptop has two large internals. Periodically I do have batch jobs on the NAS devices that run in excess of 24 hours, but not that often. Right now I have a task to batch convert 6000 TIFF files to JPG.
All of this takes me back to 1974 when I was running a System/3 Model 10 with 32k of hard memory and two removable disks. We did lots of switching in-out of disks.
Rick
Disaster Recovery = Backup ( Backup ( Your Backup ) )
July 12, 2023 at 2:19 pm
Doing things manually may be the way to go. When I first got the dlink over a decade ago it really helped by providing off-box storage. There are so many sata and usb options nowadays that I would probably not get one if starting from scratch again.
BTW back in 74 I started my first job in computing. We had twin 370/158, one with 768k and t'other with a massive 1mb. Everything was accessed via crt displays and all work came in and went out over the wire. I do remember swapping a few 3330's and a large number of tapes.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
July 12, 2023 at 3:05 pm
I do not have a recommendation. But this may be a better question to pose on a site like Toms Hardware or something similar.
True, and I do use Tom's periodically along with many other sources of info. But I do enjoy and value the real-life thoughts, opinions, and experiences of all the folks on SSC because we have so much more in common.
Rick
Disaster Recovery = Backup ( Backup ( Your Backup ) )
July 12, 2023 at 6:11 pm
BTW back in 74 I started my first job in computing. We had twin 370/158, one with 768k and t'other with a massive 1mb. Everything was accessed via crt displays and all work came in and went out over the wire. I do remember swapping a few 3330's and a large number of tapes.
Ed, I was there too. Started in 1969 on back-to-back IBM 360/50 and 360/30. Then moved to a 360/25 for a couple years, then to back-to-back 370/135 and 370/145, then on to a couple tiny System/3 Models 10 and 15. Up until the System/3 days, all our programming was on 80-column cards, then the Sys/3 had the 96-column cards before we moved our code online and used CRT's. And our off-site backup was two of us alternating taking first the old 4-platter(?) disks and then a bag of mag tapes home with us. Starting about 1976 I moved the company through Burroughs (Unisys) B1700, B1800, B1900 generations before I got into the whole Windows thing. Had a personal Apple 2+ with 5.25" floppies when they first came out, but decided that was not the way to go.
Rick
Disaster Recovery = Backup ( Backup ( Your Backup ) )
July 14, 2023 at 9:56 am
I've been using a Synology NAS for the last 10 years, having only recently had to replace the HDDs due to the risk of failure being detected via the DSM software and these were on HDDs that were desktop and not NAS specialised drives which had already seen a few years worth of use. Originally I had it as JBOD but now I have it set as a RAID due to moving family photos to it.
Compared to the WD MyBook that I had which had a failure with the hardware and when I gutted it to get the HDD out needed to use Linux to get my files off it.
If you have any questions about the Synology NAS I have (DS214play) then feel free to message me.
July 17, 2023 at 6:42 pm
I'll second the reliability of a Synology NAS. I've got a DS218+ set up with a pair of mirrored WD RED 10TB drives which has been running continuously for over 4 years so far. I've got a couple more of those drives in individual external USB enclosures that I use to back up the NAS (backups done via a robocopy script). I keep one of those externals offsite and swap them at least monthly.
As far as I know pretty much all the NAS appliances run a customized version of LINUX, so it will be tough to find one using windows compatible drives unless you build your own.
July 17, 2023 at 7:45 pm
Well, I do thank you folks for your comments and recommendations. I haven't decided yet, but I'm leaning towad going back to my 6-port USB docking strip and making multiple backups of each drive. For my needs, I guess the NAS route was probably overkill. I did build myself a rough little storage rack with shelf slots for up to 8 2.5" USB drives and a space for the docking station for two 3.5" drives. These can all be connected or detached as desired.
Here's an irony. We have a young man from SA who periodically does work for us while workinig on a Doctorate at a nearby university. He mentioned that he had a 2.5" USB drive that had failed, and had taken it to a Best Buy who guestimated $1100 to recover it. I told him I would look at it. Plugged it in, light flashes, platter spins, then it dies. Windows does not detect the device.
So I contacted DriveSavers.com who will give 'estimates', and no charge if they can't recover it. Got their estimate a while ago of a range of $700 to $3900.
Meantime, my doctorate-candidate friend says: "Well, it failed in 2014 and I haven't tried it since."
First, I'm going to buy two new drives for him, and then populate the rest of my USB drive rack so I can continue to rotate backups. I have tons of bulk data, but don't really need it all online 24/7/365. My new interpretation of NAS has become 'Not Available Storage'. And you will note my feelings about backups in my signature line.
Rick
Disaster Recovery = Backup ( Backup ( Your Backup ) )
April 7, 2024 at 1:26 am
Did you still need a solution to reading your nas drives in JOBD?
April 7, 2024 at 1:32 am
Sorry JBOD
April 7, 2024 at 4:46 am
Thanks, but no. I have retired the d-Link entirely. Still running the WD, which regularly reports some kind of power supply issue but always comes back - so far.
Rick
Disaster Recovery = Backup ( Backup ( Your Backup ) )
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply