locked
Physical Database files creation date RRS feed

  • Question

  • Hi, 

    In a SQL 2000 server , I would like to know when a particular secondary file for a database has been created.

    Is there anyway to find this??


    Thanks in advance..

     

    Wednesday, July 6, 2011 9:48 AM

Answers

  • I think I got it....

    I can use.. xp_cmdshell 'dir <<path_to_datafile>> /tc'

    it gives some information such as created date, size etc.

    • Marked as answer by MandarAlawani Wednesday, July 6, 2011 11:09 AM
    Wednesday, July 6, 2011 11:09 AM

All replies

  • Right click on the file and then properties (see create date value)
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Wednesday, July 6, 2011 9:51 AM
  • is there any way from withing SQL server, maybe by a T-SQL?
    Wednesday, July 6, 2011 10:13 AM
  • I think I got it....

    I can use.. xp_cmdshell 'dir <<path_to_datafile>> /tc'

    it gives some information such as created date, size etc.

    • Marked as answer by MandarAlawani Wednesday, July 6, 2011 11:09 AM
    Wednesday, July 6, 2011 11:09 AM