Q
Problem solve Get help with specific problems with your technologies, process and projects.

Viewing creation date of disk device

Is there anyway to find the creation date of a disk device in SQL Server 7.0?

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

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close