
Attachment uploads are currently disabled. This is a temporary situation and will resume as normal in the coming days.
UNSOLVED
I
iNetSpy_WBG
1 Rookie
•
26 Posts
0
1489
October 25th, 2021 16:00
SQL, Fastcopy and the DD that won't...
Trivia pursuit... without the use of an internet search, what is the most number of files you can have in a single directory? Second trivia question... What are the most number of files you can have on one disk?
Hint the NTFS number and the linux numbers are the same...
Yes, slightly over 4B files... btw slightly over 4B is how many you can have on the disk as well. Whether 1 directory or 1 thousand. /shrug
Now imagine you are traveling through space time... Your SQL admin has created a single directory with over 100M SQL files... If the max you can put in a directory is 4B how many can you backup?
You open the door to FASTcopy... Five days later, you are asking your provider what their definition of fastcopy is?
Avamar/DD 19.4x/DDOS 7.2x (yes actually idpa)
After registry changes we were finally able to get fastcopy to complete... 22 hours later... which is only fast when compared to the previous 5 days when it did not complete.
I believe we need to filter out some of these 100m files... SQL folks, recommendations?
Anyone else attempted to fastcopy a single Ginormous directory with 100M+ files in it?
If yes, what tweaks have you made to your DD, etc?
Responses (0)
Solutions (0)
