Merging divided tempdb files into its default setup

Question

Post reply

Merging divided tempdb files into its default setup

balasach82

SSCrazy Eights

Points: 9653
More actions
July 12, 2012 at 8:45 am

#392728

I have divided the tempdb into,
tempdb.mdf
tempdb1.mdf
tempdb2.mdf
tempdb3.mdf
templog.ldf
All the files are in same drive
Now, I have an curious doubt. How to merge all the files into its default one data and one log file?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

derek.colley SSCrazy Eights Points: 8040 More actions · Answer 1

ALTER DATABASE [tempdb]

REMOVE FILE <logical_name_1>

;

Repeat until all excess files removed, then restart SQL Server.

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

durai nagarajan SSCoach Points: 15778 More actions · Answer 2

balasach82 (7/12/2012)
I have divided the tempdb into,
tempdb1.mdf
tempdb2.mdf
tempdb3.mdf

How come .mdf files after first file?

Regards
Durai Nagarajan