How can I repeat all transactions of the transaction log for a specific date without backups in MS SQL SERVER?

Question

1C

It is necessary to repeat the commands from the transaction log for a certain period. There are no backups. I do not know what to do.

Answer 1

Egor Nikitin , If you don't have backups, then why did you decide that you have a transaction log?
In the absence of backups, there is usually a simple recovery model, and in this case the transaction log is automatically cleaned by mssql.
If the full recovery model is configured and there are no backups, then the transaction log grows constantly and usually runs out of disk space quite quickly (unless you have a very little used database).
If, nevertheless, there is a transaction log, then you can make a backup of the log. Then restore from the backup to the desired timestamp.
Before starting all operations, I recommend copying the database files to a safe place by transferring the database to offline mode - if something does not work out, just restore the files by copying.

Answer 2

Restoring a database to a specific point... . That is, make a BAK of the current state and restore a separate copy of the database from it using a timestamp.
If possible, then the documents for January 27-28 can be transferred from the temporary restored copy to the main database by external processing 1C.

Answer 3

Try Transaction Log , this program allows you to view and analyze logs, as well as recover data from them.