lfreeman Posted April 2, 2012 Report Share Posted April 2, 2012 I am backing up my production database with a Full backup weekly and log backups daily between the full backup. I am testing my backup by restoring the full snapshot to my backup SQL Server and this process works correctly. However, when I select a log snapshot I cannot cannot continue because the 'Restore database' button remains grayed out. I have tried to select other log snapshots than the most recent and I have switched the destination to the original server. Neither selection enable the 'Restore database' button. How can I restore the most recent version of the database using a combination of Full and Log backups? If I cannot restore a Log backup then what use are they? What should my backup strategy be to be able to backup and restore a complete database to my backup server? Ideally, not a full backup every day. Quote Link to comment Share on other sites More sharing options...
tom.farr Posted June 4, 2012 Report Share Posted June 4, 2012 You may repair sql logs due to next application http://www.recoverytoolbox.com/sql.html software supports restoring MS SQL Server files starting with SQL Server 2000 Quote Link to comment Share on other sites More sharing options...
mariadesouza Posted July 13, 2012 Report Share Posted July 13, 2012 I am a DBA in a small IT company. The RESTORE LOG command allows you to restore a transaction log backup. The options include restoring the entire transaction log or to a certain point in time or to a certain transaction mark. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.