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,