Database disk devices were a core component to manage databases in the SQL Server 6.5 and older platforms. The database disk device essentially corresponded to a database and a file system file. With SQL Server 7.0 and beyond, disk devices are no longer needed nor supported. Each database directly relates to a primary database file (*.mdf) and a transaction log file (*.ldf). These two files are the minimum files needed to support a SQL Server database. An additional classification of files are *.ndf files that support the data and can be configured in multiple file groups. To locate information about these files reference the sysfiles table in each user database, sysaltfiles in the master database or execute sp_helpdb to view creation date and file location information. Good luck!
For More Information
- Dozens more answers to tough SQL Server questions from Greg Robidoux and Jeremy Kadlec are available here.
- The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
- Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical SQL Server questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Microsoft SQL Server Installation
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.