I have a huge database whose backup file goes around 20 GB, because we store all documents in image format into the table.
Since we need to backup this DB everyday, this requires a lot of space in server.
All i want to do is:
1. Back whole database without that single table every day.
2. Back up that single table separately as separate bak file.. may be every week.. if possible in separate server.
Is there any way we can do this in MN SQL?
Thanks in advance.