x

Tempdb 1 MDF file and 3 LDF file Can we get same file after server restart?

Hi Usually Temp db have 1 MDF file and 1 LDF file.

My Question is

If User added 2 LDF file then

1 MDF File and 3 LDF File in SQL Server

So whether After system Restarted User 2 added LDF files existing or only default 1 MDF

file and 1 LDF File would be there in SQL Server?

more ▼

asked Jun 09, 2015 at 01:01 PM in Default

avatar image

ashok2012
420 2 5 12

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

If you are asking whether the files (.mdf and .ldf [1,2,3....n]) will be present physically on disk, then in my opinion, answer is yes. But since this is for tempDB that you specifically ask, the file contents wont be the same in both files(.mdf and .ldf), as it was before system was restarted, as tempDB will be built from scratch post such an event. 

Thus, If you ask "Can we get same file (for tempDB) after server restart?" - Answer is no.

more ▼

answered Jun 09, 2015 at 03:29 PM

avatar image

nidheesh.r.pillai
9.5k 23 59 49

(comments are locked)
10|1200 characters needed characters left

We have multiple tempdb data files and they certainly get recreated that way after a restart. I don't know about log files as we have only one. As far as I can see, there's no benefit in having more than one log file on a database unless you need more than the maximum file size ( see http://www.sqlservercentral.com/Forums/Topic1177597-1550-1.aspx).

more ▼

answered Jun 09, 2015 at 03:53 PM

avatar image

David Wimbush
10.7k 30 34 43

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x78
x4

asked: Jun 09, 2015 at 01:01 PM

Seen: 88 times

Last Updated: Jun 09, 2015 at 03:53 PM

Copyright 2017 Redgate Software. Privacy Policy