ber8630
asked on
DPM 2012 backup of SQL2012 does not seem to reduce LDF size
OK, I am not sure why, but the LDF file sizes are literally 181GB while the DBF is 32GB. I have DPM2012 backuping up the server, the databases, etc., but this file seems huge in comparison to me. I am not sure what to do to reduce the file size and keep it from consuming storage and it appers it is affecting the speed of the system (I think).
Thanks for any help.
Thanks for any help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
DBCC SHRINKFILE. Note that you should not be regularly shrinking files, just as a maintenance activity. Your log file should be right sized and left alone. The best way to think of the log file is almost like a disk drive in that it is a "container" for log records. The % of the file that is used can change but the file size should not.
You didn't say but is the database in SIMPLE or FULL recovery model? If you are not doing transaction log backups (incremental in DPM terminology) then you should be in SIMPLE. However this will eliminate your ability to do point in time restores.
If you post a bit more about your backup strategy and RPO/RTO goals we can help you design the right backup system.
You didn't say but is the database in SIMPLE or FULL recovery model? If you are not doing transaction log backups (incremental in DPM terminology) then you should be in SIMPLE. However this will eliminate your ability to do point in time restores.
If you post a bit more about your backup strategy and RPO/RTO goals we can help you design the right backup system.
ASKER
Thanks for the being patient with my delayed response. Too many irons in the fire.
So, I guess DBCC SHRINKFILE is part of some overall script or syntax I am not aware of, nor am I a DBA. Thus, my ignorance is quite clear now.
I am not exactly sure which mode it is, nor do I remember DPM asking me when I added into the protection groups. I would have probably chosen to do Full recovery.
It is interesting to me (we just switch to DPM recently) that DPM appears to be perfectly happy backing up machine in the various groups, However, the Bare Metal and System states show to be "inconsistent" more often than not.
Basically I am trying to make sure the machine and the databases are backed up every 8 hours.
So, I guess DBCC SHRINKFILE is part of some overall script or syntax I am not aware of, nor am I a DBA. Thus, my ignorance is quite clear now.
I am not exactly sure which mode it is, nor do I remember DPM asking me when I added into the protection groups. I would have probably chosen to do Full recovery.
It is interesting to me (we just switch to DPM recently) that DPM appears to be perfectly happy backing up machine in the various groups, However, the Bare Metal and System states show to be "inconsistent" more often than not.
Basically I am trying to make sure the machine and the databases are backed up every 8 hours.
The recovery model is set in the database, not by DPM. Do you have a DBA? If so you should be working with them on this to ensure everyone is on the same page. If not, post back here and we can help you.
ASKER
Sorry for the extremely slow response.
I do not have a DBA here.
Sorry on the Model question, I guess I misunderstood the question. I was able to get the log file to shrink down by switching to simple, conducting a shrink on the database, and then switched it back to Full. I also set the interval much lower to try and keep the file in hand.
I have not been able to get back around, but I know that the database backups still do not seem to be working the way I expected. So it may mean that I need to pose the question in an area for DPM as opposed to SQL, but I will let you advise me on that.
Thanks!
I do not have a DBA here.
Sorry on the Model question, I guess I misunderstood the question. I was able to get the log file to shrink down by switching to simple, conducting a shrink on the database, and then switched it back to Full. I also set the interval much lower to try and keep the file in hand.
I have not been able to get back around, but I know that the database backups still do not seem to be working the way I expected. So it may mean that I need to pose the question in an area for DPM as opposed to SQL, but I will let you advise me on that.
Thanks!
ASKER
Sorry didn't realize I left this item open and for so long.
Thanks for the help.
Thanks for the help.
ASKER