• Justin Manning SA (7/27/2015)


    Apart from the network issue, which needs to be investigated, how big is the log file and what are the VLF counts on it?

    This would also contribute to your recovery times if you have a badly fragmented log file.

    Agree in checking if instant file initialization is working for you on the server too, but will only assist with the data files being restored, not the log file.

    Over the weekend I did some VLF cleanup and shaved about 150 VLF's from the database I am trying to restore. There are still too many but I will have to try again to reduce them. I did make changes to auto-growth based on a couple of articles by Kimberly Tripp.