tags:

views:

98

answers:

1
Q: 

Piecemeal restore of database with filstream filegroups

Hi,

I have tried taking the backup of database containing filestream and it works fine. I have tried restoring it on other server also and that works too.

Now, i am facing a problem. Our database is big in size (approx. 320 GB) and it takes time to backup and restore it. Therefore, the client wants us to suggest some technique to reduce the time.

I have tried piecemeal restore which allows you to backup and restore individual filegroups in the database. It works fine with all the other filegroups except for Filestream ones. I am able to take backup and not able to restore it.

Do u have any idea??

Regards,

Prashant.

A: 

Hi,

The issue mentioned was solved by changing the recovery model of the database to Full and then taking backups and restoring them with Recovery attribute.

Thanks, Prashant.

prashant  2009-12-10 14:06:34

related questions

filestream in sql server and C# for aspx
SQL Server 2008 Filestream Error
Length of varbinary(max) filestream on MSSQL 2008
Access violation with malloc() and glDrawPixels()?
Will a using clause close this stream?
Using C# is it possible to test if a lock is held on a file
How to both Read/Write File in C#
Asynchronous operations performance
Read excel file from a stream
Convert MemoryStream to FileStream creates hundreds of identical files?
Possible reasons for FileStream.Write() to throw an OutOfMemoryException?
PHP Pass File Handle to user so that file downloads & saves to their machine
Use a MemoryStream with a function that expects a Filestream
Blocking read from FIFO via ifstream object
Larger File Streams using C#
Best way to handle a large download site?
C# Reading 'Zip' files with FileStream
Completely overwriting a file with Velocity / NVelocity
How to ensure all data has been physically written to disk?
The filestream of sql server 2008
Can I use MediaPlayer to play sounds from a stream? Or, can I use an URI to access a filestream?
How to correctly open a FileStream for usage with an XDocument
Writing to a FileStream behaves strangely, as observed by process monitor
What's the best way to write a short[] array to a file in C#?
How does one use FileStream to append to a file without an exclusive lock?