• What is your status for log backups? In order to do a page restore, you will need to bring those pages current with the rest of the database, and that means restoring log files as well. If there have truly been no changes to those pages since the backup you use, you may be able to get away without log backups. Either way, you are going to want to restore the most recent backup with a valid copy fo those pages.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]