sql server user database file create date
-
how to find sql server database file create and alter date and time
please help us
-
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/
-
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
-----------------------------------------------------------------------------
संकेत कोकणे -
sanket kokane (12/4/2012)
to get file create datexp_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 -
Thanks a lot.
it is really helpfull
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply