January 30, 2023 at 6:27 am
Hi,
I noticed that one of the database information is missing in sys.master_files catalog view today. I have nearly 14 databases but the sys.master_files has only 13 database name. One of the db information is missing. SQL Server version 2012 SP4. Can anyone let me know why this behaviour is. ?
January 30, 2023 at 9:30 am
OK, so "nearly" is not exact, so nearly 14 could actually be 13, or it could be 15 or some other random number.
Please first count the number of databases you have
SELECT COUNT(*) FROM sys.databases
What is the output of the above.
Additionally what is the output of
SELECT COUNT(*) FROM sys.master_files WHERE file_id = 2
Do the two numbers match?
If not please provide a screenshot of what is contained in sys.databases and sys.master_files
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy