Good day everyone. I have an issue today where I ran out of space on the disk partition that holds the databases and log files. I noticed that most log files are very large. My largest one is nearly 7 GB.
I run log backups twice a day, differential backup nightly, and full backup over the weekend on these databases using Backup Exec 12.5. Any idea why they are so large still and how can I get them to shrink?
I noticed that the log_reuse_wait for most DBs in the sys.databases shows as being LOG_BACKUP. What can i do to resolve this issue?
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites.
Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…