December 4, 2012 at 5:55 am
how to find sql server database file create and alter date and time
please help us
December 4, 2012 at 6:17 am
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/
December 4, 2012 at 6:17 am
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
-----------------------------------------------------------------------------
संकेत कोकणे
December 4, 2012 at 6:19 am
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 🙂
December 4, 2012 at 6:37 am
Thanks a lot.
it is really helpfull
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply