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
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.