Hi,

all databases required in order to start and function your sql instance.

master & model &resource, is required missing of this db will affect the sql server instance to start

tempdb -...

Hi,

are you seeing any I/O latency during the restore operation.

Thanks

Hi ,

You can check from the following table

sysssislog -, entry will be generated by SSIS package at runtime (when the SQL Server log provider is used)

Thanks.