Post reply

BACKUP WITH FILESTREAM TAKE LONG TIME

  • February 10, 2012 at 3:42 am

    #250603

    Hello,

    I have a SQL server 2008 R2 Entreprise Edition 64Bits with 4 processors and 8 Go for memory. Usually when I ran a full backup for a regular database (60 Go) it tooks about 20 minutes. My problem when I did the same operation for database with filestream (60Go) it tooks 6 hours. I don't understand. Do you have any idea ?

    Thanks,

    Eric

  • February 21, 2012 at 7:59 am

    #1449714

    I found the solution to resolve my issue 😛

    I executed the following step :

    - 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

Viewing 2 posts - 1 through 1 (of 1 total)

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