January 26, 2012 at 4:27 am
Hi Guys,
I seem to have an issue with filestream-enabled database backups.
SQL Server 2008 R2 Standard Edition/Windows Server 2008.
My filestream database is 12G and the backup needs 30 minutes.
I have a 100G database with BLOBS on the same server which backs up in a similar time period.
Is this backup timing correct? Is there anything I can do to increase the backup speeds?
January 26, 2012 at 6:52 am
Do you have 12Go for filestream and database or only for filestream ?
January 26, 2012 at 6:52 am
Where is it localise ypur filestream ?
January 26, 2012 at 7:18 am
Thanks for your interest.
Let me clarify
I have 2 databases - one with filestream objects needs 30 minutes to back up - this is the same amount of time as a larger database needs.
Eric - I'm not sure if I understand your localise point. The filestream files are stored on a sub-directory on my server.
January 26, 2012 at 7:25 am
So you have a database include filestream and the size is 12 Go for *mdf and filesstream. Is it correct ?
January 26, 2012 at 7:30 am
Yes - of the 12G a little data is held as tabular data but most of the data is mostly filestream. There are 4000 files - typical size is 25K but some are up to 75k.
January 26, 2012 at 7:46 am
Do you hold filestream on a specific disk (means one disk for MDF, one disk for LDF, one Disk for file stream) ?
Did you check the fragmentation of filestream's volume ?
Did you disable the option the generation of 8.3 names on all NTFS volumes on the server ?
February 21, 2012 at 8:11 am
Solution :
- Disable indexing on FILESTREAM volumes.
- Disable generation of 8.3 names on all NTFS volumes used for FILESTREAM data storage by running the below command at a command prompt.
FSUTIL BEHAVIOR SET DISABLE8DOT3 1
- Disable last file access time tracking in NTFS volumes used for FILESTREAM data storage by running the below command at a command prompt.
FSUTIL BEHAVIOR SET DISABLELASTACCESS 1
I had a same problem 7 hours to backup afer apply the below best practices the backup tooks 30min.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply