• again, thank for clarifying that Paul...

    so unless you have some hardcore redundancy, you most likely will always incur some data loss....

    you can mitigate that loss by running DBCC CHECKDB often.

    i have seen some recommendations on the web that you run it once a week and i was always puzzled by that strategy :hehe: