• if you plan to make use of snapshot, do remember its static and will have data upto point in time when snapshot is created....

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]