• I have a question about this, for example we have a big database about 100GB, and it has to move to another new server, when doing the restore, I may do in the following two ways,

    1. I create a new database with the same name and then do the restore to overwrite it in ssms.

    2. Directly do the restore database with the same name in ssms.

    If I grant the instant intialization file right to the service account, it will reduce the time for both cases, correct?

    Thanks,