question

chitrarekha.saha avatar image
chitrarekha.saha asked

Restore the database after log shipping

Tried to restore the database(read only/stand by) to a specific time which was older than the present status of the database. Is there are way to restore the database to an older version? Or do I have to depend on the full and differential backups.
sql-server-2008
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Tim avatar image
Tim answered
A log shipped database is restored up to the load delay you have configured. If you are needing a point in time before the load delay interval you will have to restore using your full, differential and logs up to the point you are trying to restore to.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.