[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

instant initialization - 4 which files?

the sql instant initialization - does it apply to all files in the server?
0
25112
Asked:
25112
  • 2
  • 2
1 Solution
 
25112Author Commented:
data, log, index- does it apply all or any?

what about system databases? does instant initialization enabled or apply to them also?
0
 
Scott PletcherSenior DBACommented:
Only non-log (.ldf) files.  Log files must always be initialized before use.
0
 
25112Author Commented:
ok.. thx.

what abt tempdb data file? (master db)
0
 
Scott PletcherSenior DBACommented:
The specific db doesn't change the way SQL works, it's the same for the whole instance.

Thus, non-log files will use IFI if it's enabled and log files will not, regardless of db.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now