• There's no guarantee that reverting to the snapshot will work. I just tested it on a corrupt database (I have several laying around) where I created a snapshot, ran repair_allow_data_loss, and then reverted to the snapshot successfully. But it's not guaranteed. You may want to take a backup first.


    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]