• State Suggested Answer
  • Locked Locked
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 16 subscribers
  • Views 2694 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Looking for a best practice to backup sql server with Netvault Plugin and VDI option including transaction logs

tobias.bonifer
over 5 years ago

Hi,

i am looking for some kind of best practices that covers the creation of a backup policy/job to do regular vdi based sql server backups including transactions and log truncation. 

Kind regards

Tobias

  • 0 over 5 years ago

    Hi

    This will depend on your environment

    there are users that do 1 full backup weekly then rest of days differentials and hourly incremental transaction logs

    there are users that do 1 full backup weekly then rest of days differentials (they have simple recovery model set on db's that doesn't requires log backups)

    there are users that do full backups all days

    there are users that do 1 full backup weekly or monthly, differentials rest of days and daily incremental transaction log

    It depends on how much logs do you generate, recovery models set for db's, the amount of work loss exposure and if recovery PIT (point in time) needed, this backups strategies should be set by a DBA that knows his environment.

    Hope the information above helps.

    Regards