Any query to find who/when the ndf file is added to the database ??

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

george sibbald SSC Guru Points: 104210 More actions · Answer 1

without auditing set up then no, but that action would be in the default trace under eventclass object:altered, object type DB.

It does not tell you exactly what was done, but it tells you an identifiable person did something.

---------------------------------------------------------------------

arnipetursson SSCertifiable Points: 6557 More actions · Answer 2

Create date/time of the physical file?

In Powershell:

$(get-childItem '<file_name_or_path>').CreationTime