it is the standard shrink command it does not give me the option to define what I shrink from what I can tell. This is the code it runs.

USE...

this maintenance.sql what does it do?

I'm a DB admin that only looks when required. My main job is everything else in the company from net admin, server admin, exchange...

I do have a full maintenance plan run every Sunday. So I retract my statement before I run a log backup appended everyday but Sunday 2AM.

in the plan I:

Check...

opc.three (7/16/2012)

---

I assume you have autogrow enabled on your log file. Check the default trace to see when it grew, that can help establishing a timeframe of when the log...

activplantdb is the one in question.

ok I just don't get it. They are back up to 66GB again.

I run a tran backup and shrink every day. I append the backup daily except for...

my second backup finally fixed this.

Log backups now down to 1.6GB for the week.

masterNOTHING

tempdbNOTHING

modelLOG_BACKUP

msdbNOTHING

ReportServerNOTHING

ReportServerTempDBNOTHING

ActivplantDBLOG_BACKUP

No I am not backing up to the same file.

full to a .bak

log to a .trn

Ok I have changed it to full recovery and the tlog is still running at 71GB. Does this make sense? Do I need to do something to get...

ChrisM@home

I think this did the trick!

Thank you very much for your help.

Using what you provided I made this:

Select i.name as Server, fd.path

FROM dbo.Inv_Installed_File_Details fd JOIN vComputer i ON i.Guid = fd._ResourceGuid

where fd.name = 'ESRDEF.BIN' and Path not like '%BinHub' AND...

can you be more specific on what you mean? by CASE?

I'm researching case now if I find something I will respond regarding this.

Update:

from what I have read about case I...

Mike, This data returns machine names and file location paths for anything found in the Inv_Installed_File_Details where the file name = 'ESRDEF.BIN' but excludes entries where the path is...

I do want to say thank you for all the help GilaMonster!

I'm a all in one admin so I can only keep up so much on my sql skills.