asked on

SQL Server - Point in time recovery help

I am trying to use point in time recovery to get data from a specific time for a table in my db. Using Manager Studio, I am restoring from a database by right clicking on the db > tasks > restore. This works. If I try and use the timeline function, I can see the the triangles representing restore points. When I go to restore, I get the error below.

Restore of database 'myDatabase' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

 

------------------------------

ADDITIONAL INFORMATION:

 

System.Data.SqlClient.SqlError: Cannot open backup device 'E:\SQL_Backup\{xxxxxxxx-xxxxxxxx-xxxxxxxx-xxxxxxxx-xxxxxxxx}14'. Operating system error 2(The system cannot find the file specified.). (Microsoft.SqlServer.SmoExtended)

Open in new window

I have tried using MSSMS as administrator and that didn't work. The recovery model is set to SIMPLE. Perhaps that is the reason?

Do I have any chance of getting this to a restore point from this method?

ASKER CERTIFIED SOLUTION

ste5an

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Scott Fell

ASKER

Thanks, I have read that already. It's odd that you can see the recovery points, but just can't get to them.

ste5an

I guess it's an SSMS UI glitch.

Daniel_PL

Hi,
Triangles doesn't mean transaction log backups, larger are full backup smaller are differential. Everything's fine with SSMS.
Did you check whether file specified in an error message is still in place?

Btw. Restore a Database Backup Using SSMS | Backup Timeline - Legend

Scott Fell

ASKER

No, I didn't find the files.

SOLUTION

DBAduck - Ben Miller

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Daniel_PL

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Scott Fell

ASKER

Thank you all for your help!

The database was set to SIMPLE and I have since changed it to FULL. The bad news is I couldn't get the back up I wanted using point in time. The good news is I did get a hold of another incremental back up and have all the data back.