I have a document management system for my company to manage company documents(~2TB, 1.5 million+ rows in File table).
DB is SQL Server 2019. File are saved as FileStream BLOB in SQL Server. Files can be downloaded/uploaded via web frontend/API.
The DB size is roughly 2TB and 95% of those are filestream blob, with about 1% per day rate.
we have problem to backup database. it takes too much time. and the other problem is we don’t have space on Raid Storage.
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 too big and we have problem for store them on a Raid Storage.
Ramon is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.