Collections:
What Is sys.database_files?
What Is sys.database_files view in SQL Server?
✍: FYIcenter.com
sys.database_files is a system view in a SQL Server Database
that contains information about each physical files used by the database.
Each record in the sys.database_files table represents a single SQL Server Physical File with the following key fields:
Here is an example of SQL Server Database with only 2 required physical files:
SELECT * FROM sys.database_files file_id type type_desc data_space_id name physical_name ... 1 0 ROWS 1 PRIMARY D:\DATA\primary.mdf ... 2 1 LOG 0 LOG D:\DATA\log.ldf ...
⇒ What Is a SQL Server Filegroup
2019-07-14, 5480🔥, 0💬
Popular Posts:
How to generate MAC addresses? To help you to obtain some MAC addresses for testing purpose, FYIcent...
What are date and time test values? Date and time test values are frequently needed in testing date ...
How to convert a date and time to a standard format? Date and time can be displayed in a number of s...
How to validate domain name format? In order to help your programming or testing tasks, FYIcenter.co...
How to generate test phone numbers for US and Canada? Test phone numbers are frequently needed in te...