Hi,

I have a question. I have a Filestream database with 1.8To of data (6900 files - 20Go for filestream). The restore database will take 17 Hours.

To improve the backup duration, I make a backup by groupfiles (see database structure below).

Basically, is it possible to restore all Groupfiles without filestream (PRIMARY_DATA filegroup) and restore it in second step ?

Functionnally, the developper team will desactivate the access to filestream to avoid any data corruption.

Regards,

Eric

/****** Object: Database [STOCKAGE] Script Date: 03/20/2015 10:03:07 ******/

CREATE DATABASE [STOCKAGE] ON PRIMARY

( NAME = N'STOCKAGE', FILENAME = N'Q:\Data\STOCKAGE.mdf' , SIZE = 70558720KB , MAXSIZE = UNLIMITED, FILEGROWTH = 524288KB ),

FILEGROUP [EMIR_ACTIVE]

( NAME = N'STOCKAGE_EMIR_ACTIVE', FILENAME = N'Q:\Data\STOCKAGE_METADONE_EMIR_ACTIVE.ndf' , SIZE = 1024000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 512000KB ),

FILEGROUP [EMIR_ARCHIVE]

( NAME = N'STOCKAGE_EMIR_ARCHIVE', FILENAME = N'Q:\Data\STOCKAGE_METADONE_EMIR_ARCHIVE.ndf' , SIZE = 1024000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 512000KB ),

FILEGROUP [METADONE_ACTIVE]

( NAME = N'STOCKAGE_METADONE_ACTIVE', FILENAME = N'Q:\Data\STOCKAGE_METADONE_ACTIVE.ndf' , SIZE = 1327169536KB , MAXSIZE = UNLIMITED, FILEGROWTH = 524288KB ),

FILEGROUP [METADONE_ARCHIVE]

( NAME = N'STOCKAGE_METADONE_ARCHIVE', FILENAME = N'Q:\Data\STOCKAGE_METADONE_ARCHIVE.ndf' , SIZE = 256683008KB , MAXSIZE = UNLIMITED, FILEGROWTH = 524288KB ),

FILEGROUP [METADONE_STATIC]

( NAME = N'STOCKAGE_METADONE_STATIC', FILENAME = N'Q:\Data\STOCKAGE_METADONE_STATIC.ndf' , SIZE = 62167040KB , MAXSIZE = UNLIMITED, FILEGROWTH = 524288KB ),

FILEGROUP [PRIMARY_DATA] CONTAINS FILESTREAM DEFAULT

( NAME = N'STOCKAGE_files', FILENAME = N'K:\FileStream\STOCKAGE_files' )

LOG ON

( NAME = N'STOCKAGE_log', FILENAME = N'H:\LOG\STOCKAGE_log.ldf' , SIZE = 8424256KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)

GO