Best Practices for SQL Trans log backups - replicate offsite

[dgaccu]

Did you not see the Veeam employee's post last August that it is on their short list?

[PTide]

Hi,

Please see this post.

Thanks!

[r0bbienz]

Guys do you still veeam backup the SQL logs or have you gone back to use native backups?

[veremin]

Can you provide a bit of context to your question? Are you experiencing any issue while backing up SQL logs with VB&R and willing to switch to native SQL solution? Thanks!

[mkretzer]

Guys do you still veeam backup the SQL logs or have you gone back to use native backups?

Sure we do! Why shouldn't we? It is so easy if you have many SQL servers and furfills 95 % of our needs.

And with instant SQL restores/publish database its so much better than native backup.

Have a 10 TB database you have to extract a few values from because someone messed something up (which we do 100x more than classic SQL disaster recovery)? No problem, ready in 5 minutes. Try that with native backup.

[r0bbienz]

Try a point in time restore via SQL Explorer - bet you it wont be in 5 mins have a try.... It will copy the whole 10TB over again before it applies the logs - surely that will take hours.....

[r0bbienz]

Can you provide a bit of context to your question? Are you experiencing any issue while backing up SQL logs with VB&R and willing to switch to native SQL solution? Thanks!

Hi Veremin - can you have a look at my post veeam-backup-replication-f2/sql-explore ... 60430.html

I want to know about point in time sql restores