<div>
<div class="content wysiwyg-content">
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. &nbsp;Can you rollback a database without using backup files.<br />
<br />
for instance<br />
transaction logs backup up once a day at 1 am. &nbsp; &nbsp;the next day someone makes a big mistake at 3 pm. &nbsp;can I roll back the database to 2:55 pm without using backup files? &nbsp;or do I have to wait until the transaction log backs up at midnight.<br />
or do I have to manually backup the transaction log now. and recovery using the backups.<br />
<br />
Whats the best way to rollback a database in this instance<br />
thank you!
</div>
</div>


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.

for instance
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
thank you!

ROLLBACK A DATABASE SERVER IN 2008 SQL IN FULL RECOVERY MODEL

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.