SQL Server Database Backup

Copper Contributor

Hi team,

I am having a doubt in SQL Server Backup process.

we are having a Database with filestream enabled and the database size is around 9 GB. the DB is created a year ago..

so we are finding a way to take the backup of the Database with file stream from a specific point of time.

 

Eg: DB is created on 4/12/2021,we need the backup of both data and filestream as backup from 4/30/2021 till now.

team kindly can you share any suggestions for this

1 Reply
Hello,
Not very clear for me what you are trying to achieve here?
You can performan a point-it-time restore, but a backup is always yet&now with the current structure and data.
If the database is in full recovery model, then you can perform the mentioned point-in-time restore.

Olaf