Topic: To find

Strongly I ask not to kick, never with it worked.
The client rings and speaks, it is necessary to clarify when in a specific field at a specific line in the specific table value has been changed. Date of transaction and that was to it is necessary simply. The table of type of the reference manual, change rare
Whether it is possible somehow  from log?


Re: To find

If there is no own history and is not included CDC is not present


Re: To find


minva wrote:

it Is possible somehow  from log?

if to be able that Reading of the transaction log of a SQL Server [/url] is possible [url=https://solutioncenter.apexsql.com/ru/%D1%87%D1%82%D0%B5%D0%BD%D0%B8%D0%B5-%D0%B6%D1%83%D1%80%D0%BD%D0%B0%D0%BB%D0%B0-%D1%82%D1%80%D0%B0%D0%BD%D0%B7%D0%B0%D0%BA%D1%86%D0%B8%D0%B9-sql-server/]


Re: To find

At the full model of recovery to recover a backup copy + log for demanded time.


Re: To find

, once it was necessary to receive exact date of removal of record. Were only  + log broad gulls.
Lifted + time 10, yet did not find approximate time +-5 minutes.


Re: To find

minva, change time rare if after changes it was not exact anything with the table - by means of DBCC PAGE search for page where the data changed, on page read m_lsn, define in backupset to what  got given lsn. Further under the link from the Grandfather read this  and search there for the record.