Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Converting from table with varbinary to Filetable Expand / Collapse
Author
Message
Posted Monday, February 17, 2014 3:03 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 8:41 AM
Points: 29, Visits: 129
I have a very large database running in a production environment. The backup files are getting to be very difficult to manage. They are at 70gb as of now and growing at a rate of 10gb per month. This is due to document images being stored in the database in one table. I have read a little about a new feature in SQL Server 2012 called Filetables. Does anyone know if we migrate to SQL Server 2012 and convert to the filetable structure, will this decrease the size of the backups? Would backup of the document images be taken care of by our nightly file system backups now? This may be worth the upgrade to SQL Server 2012.
Post #1542298
Posted Tuesday, February 18, 2014 1:58 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 10:20 AM
Points: 261, Visits: 469
I have not tried FileTables, as yet. I just googled for it, and the technet article says that the technology is built on FileStream. I do know that the FileStream data is included in the backups. So I would guess that your backup size will not go down significantly. Testing would prove this out, of course.
Post #1542737
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse