ビデオヘルプ

Handling SQL databases during incremental backups

作成: 11 Sep 2013 • 更新: 13 Sep 2013 | コメント数: 3
Caroline Kiel の写真
2 同意します
0 同意しません
+2 得票数: 2
ログインして投票

Actually users have to create two job-policies per SQL installation. One for databases in "simple" mode (only full backups) and one for "full" mode databases (full and incremental backups).

If you choose to backup all databases with only full backups, BE warns you to run incremental backups to truncate the log files, if you try to backup all databases with full/incremental policies, you get the error messages, that the "simple" databases do not support log file backups.

Therefore my question:

Why not ask the admin, how to handle "simple" mode databases during incremental backups. You could give the two options:
- Skip simple mode databses
- Failover to full backup when detecting a simple mode database during an incremental backup

This would make things much easier, especially because many admins have only few or even no know-how regarding SQL.

All the best from Germany,
Oliver

コメント コメント数: 3最新のコメントを表示

pkh の写真

I vaguely recall one post by a Symantec senior person that one of the features in the next release is the automatic handling of simple recovery mode databases.

0
ログインして投票
  • アクション
Alex Zn の写真

Agree that it should be special option for this case. But i think that BE should show some warning messagies, because if you plan to perform incremental backup, then you expect that it take much less time that full backup, so you as Backup Admin can not correctly calculate time for next backup of other systems.

0
ログインして投票
  • アクション
loori の写真

May be I lack the right bias, but shouldn't you define what flavour of SQL-DB you are talking about?

0
ログインして投票
  • アクション