ROLLBACK A DATABASE SERVER IN 2008 SQL IN FULL RECOVERY MODEL
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
Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!