Post reply

Need to clean up SYS.MASTER_FILES

  • October 10, 2018 at 11:41 pm

    #416051

    Hello, we have a SQL Server that has the following data in sys.master_files for tempdb:

    Lines 3-8 need to be removed.  They were added accidentally while attempting to move tempdb to another location.  The DDL was incorrect.  There are no physical files associated with these entries.  Is there a way to remove these entries?

    David

  • October 11, 2018 at 12:48 am

    #2008994

    Disregard.  I just used

    ALTER DATABASE [tempdb] REMOVE FILE [tempdev_2]
    GO
    ALTER DATABASE [tempdb] REMOVE FILE [tempdev_3]
    GO
    ALTER DATABASE [tempdb] REMOVE FILE [tempdev_4]
    GO

    This is no longer an issue.
    Thank you.

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

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