0

My question is how can I back up my database by controlling the log truncates?

I need to perform a testing with VEBF (Veeam Endpoint Backup FREE). A test case that I have to make now is that I have to back up Windows Server 2012 R2 as well as SQL Server 2014 with this software, ie the databases and the requirement to do so is to control the log truncates. The database I am using already has the Recovery Model "Simple".

0

VEBF appears to be a desktop/workstation backup software, and doesn't (directly) support any capability for SQL server, except for backing up SQL BAK files you have already created via a SQL native backup.

Are you talking about Veeam Explorer for Microsoft SQL Server?

If your databases are in Simple mode, you don't need to do anything to "control your log truncates". When transactions complete, SQL will automatically re-use that portion of the transaction log. If you are somewhat impatient, you can issue a "checkpoint", but that really shouldn't be necessary.

  • Correctly it does not support sql directly. I need the backups of the databases synonymous not necessarily with VEBF but with sql itself. Is there still another possibility except with the recovery model "Simple"? – j.walt Nov 22 '16 at 20:04
  • @j.walt I'm not sure that I understand your question. Simple mode means that you don't have to worry about log backups, but if something happens, you can only recover to the latest full database backup (typically nightly). If you need true "point-in-time" recovery of the databases, so if something happens you can recover right up to before the problem occurred, then you'll need to use "Full" recover model, and run frequent transaction log backups. Neither of these have anything to do with any Veeam software. – BradC Nov 22 '16 at 20:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.