file group backup restore issues

  • Hi there,

    let me know if i am not asking the right question or required any more details.

    currently we are doing a restore from our production server to our MI server every night (we are looking to do it differently in the future)

    we have recently to change from a full-backup restore to a file group restore .

    the restore duration increase from 4 hours to 6 hours .

    anyone came across a similar issues before ?

    and anyone got any resources regarding this ?

    many thanks

    Ray

  • Lots more detail required.

    What exactly do you mean by a 'file group restore'? What was restored, from what backups? What's the file/filegroup layout of the source database?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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