If you have a db in full recovery model that needs point in time recovery but the transaction log has not yet been backed up. Can you rollback a database without using backup files.
transaction logs backup up once a day at 1 am. the next day someone makes a big mistake at 3 pm. can I roll back the database to 2:55 pm without using backup files? or do I have to wait until the transaction log backs up at midnight.
or do I have to manually backup the transaction log now. and recovery using the backups.
Whats the best way to rollback a database in this instance