Link to home
Start Free TrialLog in
Avatar of electric4us
electric4us

asked on

SQL database roll back

so I have this sql database and I would like to go to a point in time. let's say 7pm yesterday. I do not have a backup of the db. is that possible from transaction log to roll back to a point in time? any tools that allow you to do that? would greatly appreciate a prompt response.
Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Andrei Fomitchev
Andrei Fomitchev
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
>> I do not have a backup of the db. is that possible from transaction log to roll back to a point in time?

Yes, you can do a Point in time Restore provided that you take a Full Backup now ( as mentioned earlier).
And the steps on how to do a point in time Restore via SSMS here:

http://msdn.microsoft.com/en-us/library/ms190982.aspx
Avatar of electric4us
electric4us

ASKER

Issue resolved.
If your issue is resolved, then kindly request you to close this question accordingly..