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, 5275🔥, 0💬
Popular Posts:
How to generate ISBN numbers? To help you to obtain some ISBN numbers for testing purpose, FYIcenter...
How to turn on Chrome WebDriver logging with Selenium Python API? If you want to turn on logging on ...
Why I am getting gzip compressed HTTP response in SoapUI? If you run a HTTP request for some Website...
How to generate currency test values? Currency test values are frequently needed in testing date and...
How to validate email address format? In order to help your programming or testing tasks, FYIcenter....