• Emil B - Friday, December 1, 2017 1:05 AM

    anjang2k - Thursday, November 30, 2017 11:08 PM

    Emil B - Thursday, November 30, 2017 6:21 AM

    what is your backup strategy? how often do you take transaction log backups?

    At present we normally do the above mentioned steps once in 5 days.We backup transaction log only when we see that the disk is going to get full.
    We can take backup in every 5 days.And keep the backup in separate location.

    Your log will be growing until you take regular log backups, like let's say every 1 hour for start - this will allow you later to do a point in time restores. You have to remember that mirroring does not protect you from all disaster scenarios (like delete data). Your database is already in FULL recovery model so might as well use it to it's full potential in terms of protecting your data.

    But how to take the backup of principal and mirror server by some maintenance schedule?