Forum Discussion

RagulVsk's avatar
RagulVsk
Copper Contributor
May 21, 2021

SQL Server Database Backup

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

DBbacup
  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    May 25, 2021
    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

Resources