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, 5136🔥, 0💬
Popular Posts:
How to perform UUDecode (Unix-to-Unix Decode)? UUEncode is Unix-to-Unix encoding used on Unix system...
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 and decode MAC (Media Access Control) addresses? In order to help your programming o...
How to access Response Status Code 400 as Success? My sampler failed, because the server returns the...
How to use HTTP protocol to post an XML message to a server? You can follow this tutorial to post an...