SQL Server Database Backup

%3CLINGO-SUB%20id%3D%22lingo-sub-2375355%22%20slang%3D%22en-US%22%3ESQL%20Server%20Database%20Backup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2375355%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20team%2C%3C%2FP%3E%3CP%3EI%20am%20having%20a%20doubt%20in%20SQL%20Server%20Backup%20process.%3C%2FP%3E%3CP%3Ewe%20are%20having%20a%20Database%20with%20filestream%20enabled%20and%20the%20database%20size%20is%20around%209%20GB.%20the%20DB%20is%20created%20a%20year%20ago..%3C%2FP%3E%3CP%3Eso%20we%20are%20finding%20a%20way%20to%20take%20the%20backup%20of%20the%20Database%20with%20file%20stream%20from%20a%20specific%20point%20of%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEg%3A%20DB%20is%20created%20on%204%2F12%2F2021%2Cwe%20need%20the%20backup%20of%20both%20data%20and%20filestream%20as%20backup%20from%204%2F30%2F2021%20till%20now.%3C%2FP%3E%3CP%3Eteam%20kindly%20can%20you%20share%20any%20suggestions%20for%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2375355%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDBbacup%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2382571%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20Server%20Database%20Backup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2382571%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3ENot%20very%20clear%20for%20me%20what%20you%20are%20trying%20to%20achieve%20here%3F%3CBR%20%2F%3EYou%20can%20performan%20a%20point-it-time%20restore%2C%20but%20a%20backup%20is%20always%20yet%26amp%3Bnow%20with%20the%20current%20structure%20and%20data.%3CBR%20%2F%3EIf%20the%20database%20is%20in%20full%20recovery%20model%2C%20then%20you%20can%20perform%20the%20mentioned%20point-in-time%20restore.%3CBR%20%2F%3E%3CBR%20%2F%3EOlaf%3C%2FLINGO-BODY%3E
New 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