Solved

instant initialization - 4 which files?

Posted on 2014-07-23
4
192 Views
Last Modified: 2014-07-31
the sql instant initialization - does it apply to all files in the server?
0
Comment
Question by:25112
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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:Scott Pletcher
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:
Scott Pletcher 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

763 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