I noticed some of my newer databases had the log file size set as 20. I increased these because I noticed the transaction logs were not being backed up. This could also be because the backup was set up as simple instead of full, not sure. I changed both and now it's okay.
In doing this, I also noticed our DYNAMICS database and a couple of company databases have their ldf file size much larger than the mdf file size. Is this normal? How do I make it smaller?
I looked into it a bit and saw the sql BACKUP LOG %dbname% with TRUNCATE_ONLY and also saw DBCC SHRINKFILE(2,20)
Would this do the trick? Can I do this on the DYNAMICS database?
Thanks!
Barb E.
In doing this, I also noticed our DYNAMICS database and a couple of company databases have their ldf file size much larger than the mdf file size. Is this normal? How do I make it smaller?
I looked into it a bit and saw the sql BACKUP LOG %dbname% with TRUNCATE_ONLY and also saw DBCC SHRINKFILE(2,20)
Would this do the trick? Can I do this on the DYNAMICS database?
Thanks!
Barb E.