x

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

sp_lock
10.8k 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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x776
x436
x247
x24

asked: Oct 24, 2014 at 01:28 PM

Seen: 243 times

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

Copyright 2017 Redgate Software. Privacy Policy