Database with FileStream

I have a database which size is only about 3GB but has file stream living on a different LUN. The FileStreamGroup LUN has about 200GB worth of data. My confusion is that the database backup is nearly 150GB (compressed).

What is included in the backup of a database that has FileStream enabled?

I have also read this article which has helped: http://www.mssqltips.com/sqlservertip/1854/how-to-backup-and-restore-a-sql-server-filestream-enabled-database/

more ▼

asked Oct 24, 2014 at 01:28 PM in Default

avatar image

sqlLearner 1
972 43 51 57

Ok I wasn't sure if the full backup included the filestream data.

Oct 24, 2014 at 02:16 PM sqlLearner 1
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

What is your confusion? Do you think the backup should be small or larger?

A full back will included the filestream data along with the standard data files. The reason why it maybe so large (if that is what you are thinking) is that some files stored may already be compressed or partially compressed by their very nature (i.e. zip, jpg etc).

more ▼

answered Oct 24, 2014 at 01:39 PM

avatar image

10.9k 27 37 37

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 24, 2014 at 01:28 PM

Seen: 250 times

Last Updated: Oct 27, 2014 at 10:19 AM

Copyright 2018 Redgate Software. Privacy Policy