where is user databases physical filename stored?

  • master..sysfiles and master..sysdevice only give the physical location of system database like master, tempdb and msdb. each user database also has their own sysfiles to tell where is the physical location of their datafile and logfile. question is when sqlserver startup, how sqlserver find out all the user database physical location and bring them online? I assume the information either in master database or in registry.

  • It's in the master.dbo.sysdatabases file.

    Tom

  • Actually I think it's also in the header information of each database's primary file.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • thank you both for help.

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

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