Database backup without Filestream data

Question

Post reply

Database backup without Filestream data

binutb

SSCommitted

Points: 1741
More actions
June 29, 2018 at 5:41 am

#370627

Hi,
My database size is 250 GB, big size due to filestream data.
How can take database backup and restore without filestream data.
pls advise
Regards
Binu
September 7, 2023 at 7:18 am

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

andreas.kreuzberg SSCertifiable Points: 6183 More actions · Answer 1

https://www.sqlservercentral.com/Forums/Topic1432371-1550-1.aspx

binutb SSCommitted Points: 1741 More actions · Answer 2

Backup required WITHOUT file stream
can tell script

Sue_H SSC Guru Points: 90860 More actions · Answer 3

binutb - Friday, June 29, 2018 5:41 AM
Hi,
My database size is 250 GB, big size due to filestream data.
How can take database backup and restore without filestream data.
pls advise
Regards
Binu

You use partial backup to exclude filestream data - it's documented in this article:
FILESTREAM Overview

Keep in mind that doesn't mean you can restore everything except the filestream data. The restores process become different from the regular restores. Just mentioned that as I thought you had some other posts with trying to reduce a database size with filestream after having removed the filestream documents. This wouldn't be how to accomplish that.

Sue

binutb SSCommitted Points: 1741 More actions · Answer 4

Hi,

Anybody can suggest script for take backup and restore database without file stream data.
My database size is 250gb.
I wish to restore the database in the same sever with different database name.

Regards
Binu

binutb SSCommitted Points: 1741 More actions · Answer 5

Hi,

I have taken backup FILEGROUP = PRIMARY and successfully restored that data file.

script used for back and restore database as below

-- Take a backup

BACKUP DATABASE NorthPole
FILEGROUP = 'PRIMARY'
TO DISK = 'C:\ArtOfFS\Demos\Chapter8\bak\NorthPolePrimary.bak' GO

-- RestoreRESTORE DATABASE NorthPolePartial
FROM DISK = 'C:\ArtOfFS\Demos\Chapter8\bak\NorthPolePrimary.bak'
WITH RECOVERY,
PARTIAL,
MOVE 'NorthPole' TO 'C:\ArtOfFS\Demos\Chapter8\NorthPolePartial.mdf',
MOVE 'NorthPole_log' TO 'C:\ArtOfFS\Demos\Chapter8\NorthPolePartial_log.ldf'

Database property File tab, File stream entries still exist.
below error when tried to delete file stream entries

Drop failed for DataFile < file stream logical file name> (Microsoft.SqlServer.Sno)

FILESTREAM's file system log record '$Recycle.Bin' under log folder is corrupted ( Microsoft SQL Server, Error:5511)

I want to remove old file stream entries and add new one

Regards
Binu