Home Forums SQL Server 2005 Administering sql server user database file create date RE: sql server user database file create date

  • December 4, 2012 at 6:19 am

    #1565262

    sanket kokane (12/4/2012)

    to get file create date

    xp_cmdshell 'dir <your Datafile Path> /tc'

    or

    right click on data file at physical location and check create time

    Wonderful. 🙂 Sometimes we need to think simple 🙂