We have close to 5 Databases .
Below are the .mdf and .ldf sizes .
NOTE : Along with this we do also have the FileStream enabled for these Databases .
Kindly suggest me on below :
As of now we are using the third party tool for Backing up the data for these databases .
Most importantly they are appending backup files and now they have grown close to 800 GB .
After all , now I am just thinking of proposing the idea of daily individual files instead of appending the backup files daily and letting them grow huge .
I am thinking of it for two reasons .
- For Restore of the Database from backup file in a little comfortable way , than restoring a huge file .
- Next , I am thinking it will be easy to purge the backup files easily , I mean the old backup files .
- Backup file maintenance , we can maintain last 5 days or so and remove the previous ones .
Please let me know :
What will be the disadvantage of my above plan .
How is it different from appending backup files and daily individual backup files with Date Time Stamp appended to the filename daily basis .
Will the Database backup also includes the FileStream Data ?
How better I would have thought than what I am thinking now . Which is more recommended and better , Overwrite / Append / Individual Backup Files with Date-Time Stamp ?
Thanks for all your time .