Solved

instant initialization - 4 which files?

Posted on 2014-07-23
4
183 Views
Last Modified: 2014-07-31
the sql instant initialization - does it apply to all files in the server?
0
Comment
Question by:25112
  • 2
  • 2
4 Comments
 
LVL 5

Author Comment

by:25112
ID: 40214901
data, log, index- does it apply all or any?

what about system databases? does instant initialization enabled or apply to them also?
0
 
LVL 69

Expert Comment

by:ScottPletcher
ID: 40215113
Only non-log (.ldf) files.  Log files must always be initialized before use.
0
 
LVL 5

Author Comment

by:25112
ID: 40215642
ok.. thx.

what abt tempdb data file? (master db)
0
 
LVL 69

Accepted Solution

by:
ScottPletcher earned 500 total points
ID: 40217013
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now