Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server user database file create date Expand / Collapse
Author
Message
Posted Tuesday, December 4, 2012 5:55 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 14, 2014 2:40 AM
Points: 14, Visits: 247
how to find sql server database file create and alter date and time
please help us
Post #1392401
Posted Tuesday, December 4, 2012 6:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:46 PM
Points: 42, Visits: 290
Hello,

Not sure if you can get the info for files added/ altered alreadt but to track the changes in future, you need to configire DDL triggers to capture this information.

Check the below link for more info...

http://www.mssqltips.com/sqlservertip/2085/sql-server-ddl-triggers-to-track-all-database-changes/
Post #1392414
Posted Tuesday, December 4, 2012 6:17 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 1, 2013 10:17 AM
Points: 323, Visits: 984
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


-----------------------------------------------------------------------------
संकेत कोकणे
Post #1392415
Posted Tuesday, December 4, 2012 6:19 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:46 PM
Points: 42, Visits: 290
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 :)
Post #1392417
Posted Tuesday, December 4, 2012 6:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 14, 2014 2:40 AM
Points: 14, Visits: 247
Thanks a lot.

it is really helpfull
Post #1392436
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse