Home > database >  Question about SQL server file stream file group, who answer ah
Question about SQL server file stream file group, who answer ah

Time:09-18

There is now a library, store some daily ran a single data
Libraries have an attachment table (PDF, EXCEL, JPG, etc.), one of the data type of the field to varbinary (Max)
Users on the client to upload attachments, through the program code will be converted to binary byte streams found attachment table

But business is more, life is long, attachment memory also larger
The library is also growing

So special file stream file group, the data stored in the external, rather than the database itself

But now there are a few problems:
1. The size of the library itself is about 40 g, why a full backup file size to 200 g?
2. If I want to restore the database by backup files in other server, how should operate, as well as normal file recovery?
3. Attachment file flow exists has gone through a folder, I wonder how he and the data in the database of one to one correspondence?

Hope everybody who help solve, thank you thank you
  • Related