November 26, 2004 at 6:54 am
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.
November 26, 2004 at 7:19 am
It's in the master.dbo.sysdatabases file.
Tom
November 26, 2004 at 7:31 am
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]
November 26, 2004 at 7:37 am
thank you both for help.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply