Sample Header Ad - 728x90

how to divide a filetable to several filetable on several disk in sql server?

0 votes
2 answers
89 views
I have a dms database that use filestream. I want to distribute data to several disk based on year. How can I divide this database to several disk in sql server? I used Partitioning technique but I consider it dosen't support filetable. Now I create 3 filestreams group and 3 filegroups. when I insert data to these 3 filetables, show error on constraint of filetable, path_locator, file_type and cached_file_size. How to partitioning Manual filetable? --- I have a document management system for my company to manage company documents(~2TB). Considering this scenario, what would be the best strategy for us regarding SQL Maintenance (backup, restore , etc.) and best use of storage space? How can we reduce the volume of database on raid storage? Challenges we are facing: Full Backup will take too much time. DB Restore will take very long time if any disaster happened. Database and Backup file size are too big and we have problem for storing them on a Raid Storage. I want partitioned or divide my filetable. and store my blob filestreams on several filegroup (several directory on several disk). how to do it and how to move recoreds of main filetable to my new filetables based on creation_time and store filestreams to new directories. This scenario make backup & restore process faster by backup & restore based on filegroup
Asked by Ramon (11 rep)
Aug 25, 2024, 09:18 PM
Last activity: Aug 28, 2024, 09:22 AM