Posted by New MSSQL DBA on 11/22/05 04:41

Hi all, I have a tempdb that consists of 8 datafiles, tempdb_data_1 to
tempdb_data_8, each is 8GB. Now how can I drop 7 of them and leave
only tempdb_data_1? Can this be done? Thanks a lot.

• Next in forum: Re: Limit saving DTS package to SQL Server
• Prev in forum: Re: problem with Select query
• Thread view: How to drop one of the tempdb files

[Reply to this message]