• Saber_Talas,

    Snapshot is available in Enterprise edition only. If You have it, you can go ahead with snapshot.

    Log shipping (with Standby mode) will you give more convenience than snapshot. But the problem is log restore and user connection are not mutally compatible, ie, user cant connect to database while restore happens or vice-versa. So you will need to balance in timing of these two activities.